SQL查询表中最后一条数据

准备数据表

建立student表,并插入几条数据

查询最后一条数据

本文共分为三种方式

//max(id) 函数
select * from student where id = (select max(id) from student);

//order by id desc limit 1
select * from student order by id desc limit 1;

//last_insert_id() 函数
select * from student where id = (select last_insert_id());
Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐