LAST_INSERT_ID « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. LAST_INSERT_ID
1.Save the result from LAST_INSERT_ID( ) after creating a new record in a table that has an AUTO_INCREMENT column to a variable
2.Each time a conference registration form is received, enter the attendee information into the attendee table.
3.Update with LAST_INSERT_ID
4.Using LAST_INSERT_ID() in insert statement
5.To see what the new seminar records look like, use the LAST_INSERT_ID() value to retrieve them:
6.Use the new value to retrieve the entire record, without even knowing what the id is