In-depth analysis of the usage of limit in Mysql _mysql

SELECT * FROM table limit m,n where M is the index at which the record starts, from 0, N is the beginning of article M, and N is taken.

Copy Code code as follows:

MySQL (root@localhost:test) >select * from Total;
+----+-----------------+--------+------------+
| ID | name | number | MyDate |
+----+-----------------+--------+------------+
| 1 |   Henan Publishing House | 1000 | 2008-03-24 |
| 2 |   Henan Publishing House | 1200 | 2009-04-24 |
| 3 |   Henan Publishing House | 1100 | 2010-04-24 |
| 4 |   Henan Publishing House | 1400 | 2011-04-24 |
| 5 |   Henan Publishing House | 1350 | 2012-04-24 |
| 6 |   Beijing Publishing House | 2000 | 2008-03-24 |
| 9 2   Beijing Publishing House | 2020 | 2009-04-24 |
| 8 |   Beijing Publishing House | 2050 | 2010-04-24 |
| 9 |   Beijing Publishing House | 1980 | 2011-04-24 |
| 10 |   Beijing Publishing House | 2100 | 2012-04-24 |
+----+-----------------+--------+------------+
Rows in Set (0.00 sec)

MySQL (root@localhost:test) >select * from Total limit 2, 3;
+----+-----------------+--------+------------+
| ID | name | number | MyDate |
+----+-----------------+--------+------------+
| 3 |   Henan Publishing House | 1100 | 2010-04-24 |
| 4 |   Henan Publishing House | 1400 | 2011-04-24 |
| 5 |   Henan Publishing House | 1350 | 2012-04-24 |
+----+-----------------+--------+------------+
3 Rows in Set (0.00 sec)

That's roughly what it means.