摘要:
利用子查询示例: SELECT * FROM your_table WHERE id <= (SELECT id FROM your_table ORDER BY id desc LIMIT ($page-1)*$pagesize ) ORDER BY id desc LIMIT $pagesize 阅读全文
posted @ 2016-07-05 21:56 moss_tan_jun 阅读(179) 评论(0) 推荐(0)
|
摘要:
利用子查询示例: SELECT * FROM your_table WHERE id <= (SELECT id FROM your_table ORDER BY id desc LIMIT ($page-1)*$pagesize ) ORDER BY id desc LIMIT $pagesize 阅读全文
posted @ 2016-07-05 21:56 moss_tan_jun 阅读(179) 评论(0) 推荐(0) |
||