选择 MySQL 中的最后一行
2021-11-20 00:00:00
mysql
如何SELECT MySQL 表的最后一行?
How can I SELECT the last row in a MySQL table?
我正在INSERT输入数据，我需要从前一行检索列值.
I'm INSERTing data and I need to retrieve a column value from the previous row.
表中有一个auto_increment.
推荐答案
是的，里面有一个 auto_increment
Yes, there's an auto_increment in there
如果你想要表中所有行中的最后一个，那么现在终于到了 MAX(id) 是正确答案的时候了！种类:
If you want the last of all the rows in the table, then this is finally the time where MAX(id) is the right answer! Kind of:
SELECT fields FROM table ORDER BY id DESC LIMIT 1;
相关文章