MySQL 分页

limit start,count 获取部分行

从start开始，获取count条数据start索引从0开始

select * from user limit 0,5;

+----+------+------+---------------------+--------+------+----------+
| id | name | age  | birthday            | gender | home | isdelete |
+----+------+------+---------------------+--------+------+----------+
|  1 | 刘备     |   37 | 2000-01-01 00:00:00 | 
      | 蜀     |          |
|  2 | 关羽     |   36 | 2000-01-01 00:00:00 | 
      | 蜀     |          |
|  3 | 张飞    |   35 | 2000-01-01 00:00:00 | 
      | 蜀     |          |
|  4 | 曹操    |   40 | 2000-01-01 00:00:00 | 
      | 魏    |          |
|  5 | 曹丕    |   20 | 2000-01-01 00:00:00 | 
      | 魏    |          |
+----+------+------+---------------------+--------+------+----------+
5 rows in set (0.00 sec)