MySQL - 选择最后插入的行的最简单方法

2021-12-19 00:00:00 select mysql

我只需要选择由条件指定的最后输入的行，例如:

I simply need to select the last entered row specified by condition, e.g:

SELECT ID from bugs WHERE user=Me

我只需要返回用户我"输入的最后一个 ID.有没有一种简单的方法可以做到这一点?谢谢.

I need to return only the very last ID entered by user 'Me'. Is there a simple way to do this? Thank you.

推荐答案

最好有一个 TIMESTAMP 列，默认为 CURRENT_TIMESTAMP ..它是唯一的您可以在此处找到真正的预测行为.

It would be best to have a TIMESTAMP column that defaults to CURRENT_TIMESTAMP .. it is the only true predictive behavior you can find here.

你能做的第二好的事情是ORDER BY ID DESC LIMIT 1并希望最新的ID是最大值.

The second-best thing you can do is ORDER BY ID DESC LIMIT 1 and hope the newest ID is the largest value.

相关文章