获取MySQL中最后删除的ID [英] Get last deleted ID in MySQL

问题描述

与LAST_INSERT_ID()类似，MySQL中是否有一种不错的机制可以在删除一行后获取最后删除的ID?

Similar to LAST_INSERT_ID(), is there a nice mechanism in MySQL to get the last deleted ID after a row has been deleted?

推荐答案

通过"ID"，我假设您的意思是自动增量"?

By "ID", I assume you mean "auto-increment"?

由于您可以随时删除任何任意行(或一组行):否，因此无法告诉您最近删除的WHICH行(一个或多个行).

Since you can delete any arbitrary row (or set of rows) at any time: no, there's no way to tell WHICH row (or rows) you most recently deleted.

您可以，但是，创建一个触发器"来为您保存此信息:

You can, however, create a "trigger" to save this information for you:

http://dev.mysql.com/doc/refman/5.0/en/triggers.html

这篇关于获取MySQL中最后删除的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！