摘要:        
利用子查询示例: 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 阅读(178) 评论(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 阅读(178) 评论(0) 推荐(0) | ||