mysql倒序查询 mysql倒排

源源今天给分享mysql倒序查询的知识，其中也会对mysql倒排进行解释，希望能解决你的问题，请看下面的文章阅读吧！

1、INSERT INTO T (email) VALUES ('瞎子','zhangsh1234@163'), ('剑圣','lisi1998883@163'), ('露娜','zhangssxyz@163'), ('李白','zhangsy1998@163'), ('韩信','zhaq5481993@163'), ('百里玄策','hhaq5481993@163');select from userlist order by id desc limit 5;说明：id是自增id的情况下用这个，当然也可用插入时间来排序例如这样：select from userlist order by created_at desc limit 5;select from table order by id desc limit 正序排序 select from test where id > (select max(id-20)from test) ;5;说明：以自增主键，或者添加时间倒序排序，加上limit条件就能到达要求select from userlist order by uid desc limit 5 或者：SELECT FROM `userlist` ORDER BY `uid` DESC LIMIT 0,5select from yourTable order by id desc limit 5select top 5 from userlist order by id descselect from 表名 order by 字段 desc limit 5;select from userlist order by id desc limit 5;。

本文到这结束，希望上面文章对大家有所帮助。