[Mysql]查询优化
2020/09
18
15:09
只查询前N个记录的数据
select id from tablename where id in (select id from ( select id from tablename order by id desc limit 10) as id );
// 即从tablename中取前10个，再查询CopyRights: The Post by BY-NC-SA For Authorization，Original If Not Noted，Reprint Please Indicate From 老刘@开发笔记
Post Link: [Mysql]查询优化
Post Link: [Mysql]查询优化