×îÓÐЧÂʵÄsqlÓï¾ä£¬ÕÒµ½×îºóÒ»Ìõ¼Ç¼(MySql)

idµÝÔö£¬ÈçºÎ×îÓÐЧÂÊÕÒµ½×îºóÒ»Ìõ¼Ç¼£¿£¿

---

select * from tt order by id desc limit 1
or
select a.* from tt a
inner join
(select max(id) as ma from tt) b
on a.id=b.ma

---

select * from ±íÃû order by id desc limit 1

---

ʹÓÃhibernate3ÓÃHQLÓï¾äÈçºÎд£¿£¿

---

ÄãµÄHQLÖÐÓÐûÓÐÅÅÐò£¿

ÔÚÄãµÄË÷Òý×Ö¶ÎÉÏÓýµÐòÈ¡µÚÒ»ÌõЧÂÊÊÇ×î¸ßµÄÁË¡£

---

from MisGoods order by id desc limit 1;

ÕâÌõÓï¾äÀÏÊDz»¹ÜÓã¬ÊDz»ÊÇÔÚHQLÖв»ÄÜÓÃlimitÏÞÖÆ

---

select a.* from tt a
inner join
(select max(id) as ma from tt) b
on a.id=b.ma
Õâ¸öÄÜÔËÐÐÂð£¿

---

ÒýÓÃ

select a.* from tt a
inner join
(select max(id) as ma from tt) b
on a.id=b.ma
Õâ¸öÄÜÔËÐÐÂð£¿

¿ÉÒÔ

---

HQL£¬ÊǺܶàÊý¾Ý¿âµÄ¸öÐÔ»¯Óï¾äÎÞ·¨Ö´Ðеġ£Ö»ÄÜÓñê×¼µÄsql£¬»òÕßÖ±½ÓÈÃËûÖ´ÐÐsql¡£