limit用法
概念
返回mysql 数据库查询的限定条数
SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offset
limit 后面可接1个或者2 个参数 。参数必须是整数常量 0 ->正无穷
== mysql 的下标是从 0 开始的== 如下,返回数据库第一条数据
SELECT * FROM `table` order by id LIMIT 0,1
或
SELECT * FROM `table` order by id LIMIT 1
如下 查不出数据 --从0 开始查询0条数据]
SELECT * FROM `student` order by sid LIMIT 0,0
1.1个参数的情况
select * from table limit A
A 代表返回多少条数
类似于下面这样子的写法
select * from table limit 0, A
2.2个参数的情况
select * from table limit A ,B
A 代表从A+1行开始且包括A+1行,B 代表返回多少条数据 mysql 下标是从==0 ==开始的
如下 : 从第二行开始计算
下面提供一个表方便测试
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`SId` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`Sname` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`Sage` datetime(0) DEFAULT NULL,
`Ssex` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
INSERT INTO `student` VALUES ('01', '赵雷', '1990-01-01 00:00:00', '男');
INSERT INTO `student` VALUES ('02', '钱电', '1990-12-21 00:00:00', '男');
INSERT INTO `student` VALUES ('03', '孙风', '1990-05-20 00:00:00', '男');
INSERT INTO `student` VALUES ('04', '李云', '1990-08-06 00:00:00', '男');
INSERT INTO `student` VALUES ('05', '周梅', '1991-12-01 00:00:00', '女');
INSERT INTO `student` VALUES ('06', '吴兰', '1992-03-01 00:00:00', '女');
INSERT INTO `student` VALUES ('07', '郑竹', '1989-07-01 00:00:00', '女');
INSERT INTO `student` VALUES ('09', '张三', '2017-12-20 00:00:00', '女');
INSERT INTO `student` VALUES ('10', '李四', '2017-12-25 00:00:00', '女');
INSERT INTO `student` VALUES ('11', '李四', '2017-12-30 00:00:00', '女');
INSERT INTO `student` VALUES ('12', '赵六', '2017-01-01 00:00:00', '女');
INSERT INTO `student` VALUES ('13', '孙七', '2018-01-01 00:00:00', '女');