SeaRiver Blog

实力才是你一生最好的依靠!

日志

关于我

SeaRiver

强者恒强,弱者恒弱!

文章分类

LOFTER精选

八招诀窍，教你实力撩妹 >

各种MySQL版本中已实现的主要特性或规划中的特性

2008-02-28 04:43:39| 分类： MySQL | 标签： |举报 |字号大中小订阅

下载LOFTER 我的照片书 |

在下面的表格中，归纳了要求最迫切的特性，以及实施了这些特性或计划实施这些特性的版本：

特性	MySQ系列
Foreign keys	3.23（针对InnoDB存储引擎）
Unions	4.0
Subqueries	4.1
R-trees	4.1（针对MyISAM 存储引擎）
Stored procedures	5.0
Views	5.0
Cursors	5.0
XA transactions	5.0
Foreign keys	5.1（在3.23中实施，对于InnoDB）
Triggers	5.0和5.1
Full outer joins	5.1
Constraints	5.1（在3.23中实施，对于InnoDB）
Partitioning	5.1
Pluggable Storage Engine API	5.1
Row-Based Replication	5.1

评论这张

转发至微博

阅读(487)| 评论(0)

历史上的今天

this.p={  m:2,
              b:2,
              loftPermalink:'',
              id:'fks_084066084086088071092082080095085095089067084084087068',
              blogTitle:'各种MySQL版本中已实现的主要特性或规划中的特性',
              blogAbstract:'<P\>在下面的表格中，归纳了要求最迫切的特性，以及实施了这些特性或计划实施这些特性的版本： </P\>\r\n<P\>\r\n<TABLE cellPadding=0 border=1\>\r\n<TBODY\>\r\n<TR\>\r\n<TD\>\r\n<P\><B\>特性</B\></P\></TD\>\r\n<TD\>\r\n<P\><STRONG\><SPAN\>MySQ系列</SPAN\></STRONG\></P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>Foreign keys</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>3.23</SPAN\>（针对<SPAN\>InnoDB</SPAN\>存储引擎）</P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>Unions</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>4.0</SPAN\></P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>Subqueries</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>4.1</SPAN\></P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>R-trees</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>4.1</SPAN\>（针对<SPAN\>MyISAM</SPAN\><SPAN\> </SPAN\>存储引擎）</P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>Stored procedures</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>5.0</SPAN\></P\></TD\></TR\>\r\n<TR\>\r\n<TD\>\r\n<P\><SPAN\>Views</SPAN\></P\></TD\>\r\n<TD\>\r\n<P\><SPAN\>5.0</SPAN\></P\></TD\></TR\>\r\n</TABLE\></P\>',
              blogTag:'',
              blogUrl:'blog/static/19800217200812844339508',
              isPublished:1,
              istop:false,
              type:0,
              modifyTime:0,
              publishTime:1204145019508,
              permalink:'blog/static/19800217200812844339508',
              commentCount:0,
              mainCommentCount:0,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              currentRecomBlog:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'',
              visitorCity:'',
              visitorNewUser:false,
              postAddInfo:{},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:false,
              hostIntro:'强者恒强,弱者恒弱!',
              hmcon:'1',
              selfRecomBlogCount:'0',
              lofter_single:'<iframe width="140" height="560" style="overflow:hidden;" src="http://www.lofter.com/mailEntry.do?blogad=1&blog" frameBorder="0"></iframe>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/19800217200812844339508">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇，下一篇--> <#-- 热度 -->

{list a as x}
    {if !!x}
    <div class="hotItem iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
      {if x.publisherUsername==visitor.userName}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
          ${fn(x.publisherNickname,8)|escape}
        </a>
      </div>
      <a class="f-myLikeIcons hottype {if x.type==1} js-liketype{elseif x.type==2} js-reblogtype{elseif x.type==3} js-sharetype{else}{/if}" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/"> </a>
    </div>
    {/if}
    {/list}

<#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

我的照片书 - 博客风格 - 手机博客 - 下载LOFTER APP - 订阅此博客

SeaRiver Blog

导航

日志

各种MySQL版本中已实现的主要特性或规划中的特性

历史上的今天

最近读者

热度

评论

页脚