mysql分页查询语句怎么写?

Question

mysql分页查询语句怎么写

Answer 1

--1.最常用的分页select * from content order by id desc limit 0, 10;--limit是MySQL中特有的分页语法，用法如下：--举例：select * from tableName limit 5; --返回前5行select * from tableName limit 0,5; --同上，返回前5行select * from tableName limit 5,10; --返回6-15行