mysql 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', '女');