1,sql语句limit的使用方法
<style> <!-- .O {font-size:149%} --> </style><style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
SELECT * FROM table ……
limit
开始位置
,
操作条数
开始位置从
0
开始
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
SELECT * FROM table ……
limit0, 20
取最前面20条
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
SELECT * FROM table ……
limit10, 20
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
11
条到20条
2、分页原理
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
所谓分页显示,也就是讲数据库中的结果集,一段一段显示出来
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
需要的条件
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
怎么分段,当前在第几段(每页有几条,当前再第几页)
前10条记录:select * from table limit 0,10
第11至20条记录:select * from table limit 10,10
第21至30条记录:select * from table limit 20,10
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
得到公式
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
(当前页数 - 1 )X每页条数,每页条数
Select * from table limit ($Page- 1) * $PageSize, $PageSize
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>
<style> <!-- .O {font-size:149%} --> </style> <style media="print"> <!-- .sld {left:0px!important; width:6.0in!important; height:4.5in!important; font-size:103%!important} --> </style>