sql server - MySQL INSERT with OUTPUT like MSSQL

Question

I am pretty sure MySQL does not have the INSERT INTO table OUTPUT [column value] that MSSQL does - http://msdn.microsoft.com/en-us/library/ms177564.aspx (or http://blogs.msdn.com/b/sqltips/archive/2005/06/13/output-clause.aspx)

What's an easy way to replicate this? (I am moving a MSSQL app to MySQL. The 'OUTPUT' is a unique identifier and a int currently, so maybe I could just SELECT MAX (int) and add one, and generate a UID prior to insert?)

Thanks

Answer 1

If this value is an auto-increment field, you can run SELECT LAST_INSERT_ID(); after running the insert, and you'll get the last value inserted into this field. See: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id