数据库表:fp_studentItem
![在这里插入图片描述](https://img-blog.csdn.net/20180829115128335?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2pvdmlfemhhbw==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70#pic_center)
- 方法一:不推荐
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
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)