Search code examples
mysqlsqldatabase

Get last deleted ID in MySQL

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

Solution

  • 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