分页的MYSQL语句

分页的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 ?,?