Similar to LAST_INSERT_ID(), is there a nice mechanism in MySQL to get the last deleted ID after a row has been deleted?
LAST_INSERT_ID()
By "ID", I assume you mean "auto-increment"?
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
2.1m questions
2.1m answers
60 comments
57.0k users
