Question

求mysql倒序并且限制查询的条数的查询语句？

Answer 1

select * from yourtable where 查询条件 order by id desc limit 0,10;
按id倒序排列，且取前10条。