分页的MYSQL语句
1直接分页语句
SELECT * FROM css_news ORDER BY id LIMIT 1, 5
2按条件的分页语句,从表中选出news_subchanel=1的信息组成一张表,
再在这张表中进行分页
SELECT * FROM (SELECT * FROM css_news WHERE news_subchanel=1) AS new1 ORDER BY id LIMIT 1, 100;
3总结分页语句
select * from table [查询条件] order by id limit ?,?
分页的MYSQL语句
最新推荐文章于 2022-02-11 21:41:55 发布