MySQL-选择最后插入的行是最简单的方法 [英] MySQL - Select the last inserted row easiest way

问题描述

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

SELECT ID from bugs WHERE user=Me

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

解决方案

最好有一个默认为CURRENT_TIMESTAMP的TIMESTAMP列.这是您在这里可以找到的唯一真实的预测行为.

您可以做的第二件事是ORDER BY ID DESC LIMIT 1，希望最新的ID是最大值.

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

SELECT ID from bugs WHERE user=Me

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

解决方案

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.

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

这篇关于MySQL-选择最后插入的行是最简单的方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！