常用数据库分页代码
发布时间:2018-10-31 编辑:jiaochengji.com
教程集为您提供常用数据库分页代码等资源,欢迎您收藏本站,我们将为您提供最新的常用数据库分页代码资源
<span style="font-weight: bold">MySQL</span>
sql 代码
<ol class="dp-sql"> <li class="alt"><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat limit ?,? </span></span></li> <li class=""><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat limit 20000,100 </span></span></li> <li class="alt"><span>从Cat表中第20000条开始取出100条记录,即记录号为20000到20099的记录 </span></li> <li class=""><span> </span></li> <li class="alt"><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat limit ? </span></span></li> <li class=""><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat limit 100 </span></span></li> <li class="alt"><span>从Cat表中取出记录号为1到100的记录 </span></li> <li class=""><span> </span></li> <li class="alt"><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat </span><span class="keyword">order</span><span> </span><span class="keyword">by</span><span> rand() limit ? </span></span></li> <li class=""><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> Cat </span><span class="keyword">order</span><span> </span><span class="keyword">by</span><span> rand() limit 100 </span></span></li> <li class="alt"><span>从Cat表中随机取出100条记录 </span></li> </ol>
<span style="font-weight: bold">Oracle</span>
sql 代码
<ol class="dp-sql"> <li class="alt"><span><span class="keyword">select</span><span> * </span><span class="keyword">from</span><span> (</span><span class="keyword">select</span><span> *, rownum rownum_ </span><span class="keyword">from</span><span> Cat </span><span class="keyword">where</span><span> rownum <= ?) </span><span class="keyword">where</span><span> rownum_ > ?</span></span></li> </ol>
您可能感兴趣的文章:
mysql中操作数据表的一些命令
用PHP MySQL进行分页的详细说明(一)
php实现分页的原理及步骤
有关php分页显示的制作方法
JSP 怎么提高数据库访问效率
嵌入式数据库H2安装图解
mysql导出数据库多种方法
ajax异步刷新实现更新数据库
PostgreSQL从菜鸟到专家系列教程(5)什么是数据库管理系统
jquery easyui 分页的使用方法