Limit:
限制获得的记录数量.
(放在最后)
语法:
Limit M ,N
M=Offset 偏移量 从0开始(可以省略,默认为0)
N=Row count 总记录数
/*简单示例*/
use php_one;
create table t11(
a int
);
insert into t11 values(5);
insert into t11 values(10);
insert into t11 values(15);
insert into t11 values(7);
insert into t11 values(8);
insert into t11 values(50);
insert into t11 values(3);
insert into t11 values(1);
insert into t11 values(35);
select * from t11 limit 2,3; /*15 7 8*/
select * from t11 order by a limit 1,3; /*3 5 7*/