Mysql实现从查询的多条数据中取出最新一条数据

数据库表：fp_studentItem

方法一：不推荐 SELECT * FROM fp_studentItem where id=( SELECT MAX(id) FROM fp_studentItem where studentid=1) 方法二：推荐 SELECT * FROM fp_studentItem WHERE studentid=1 ORDER BY id DESC LIMIT 1