mysql取最后五条记录

select * from userlist order by created_at desc limit 5;
mysql取最后五条记录
select * from userlist order by id desc limit 5;说明:id是自增id的情况下用这个,当然也可用插入时间来排序例如这样:
select * from userlist order by created_at desc limit 5;2017-07-25
sql语句:
select * from table order by id desc limit 5;说明:
以自增主键,或者添加时间倒序排序,加上limit条件就能到达要求
2017-07-08
select * from userlist order by uid desc limit 5 或者:
SELECT * FROM `userlist` ORDER BY `uid` DESC LIMIT 0,52013-03-27
select * from yourTable order by id desc limit 52013-03-26
select top 5 * from userlist order by id desc2013-03-27
select * from 表名 order by 字段 desc limit 5;2017-08-09
select * from userlist order by id desc limit 5;2013-03-27
select * from 表名 order by 主键自增id desc limit 5
黑马程序员的PHP是国内最早开设的真正人工智能课程。课程全面系统,紧跟时代潮流。2017-07-28
mengvlog 阅读 52 次 更新于 2025-10-28 16:12:44 我来答关注问题0
檬味博客在线解答立即免费咨询

mySQL相关话题

Copyright © 2023 WWW.MENGVLOG.COM - 檬味博客
返回顶部