MySQL LAST_INSERT_ID() used with multiple records INSERT statement

by

Yes. This behavior of last_insert_id() is documented in the MySQL docs:

Important
If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only. The reason for this is to make it possible to reproduce easily the same INSERT statement against some other server.

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. How to set initial value and auto increment in MySQL?
  3. How to do a batch insert in MySQL
  4. LAST_INSERT_ID() MySQL
  5. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  6. Increment a database field by 1
  7. Prevent auto increment on MySQL duplicate insert
  8. How to program a MySQL trigger to insert row into another table?
  9. How to copy a row and insert in same table with a autoincrement field in MySQL?
  10. MySQL Error 1264: out of range value for column
  11. BULK INSERT in MYSQL
  12. How do I get the ID of multiple inserted rows in MySQL?
  13. Importing a CSV to MySQL with different date format
  14. How to insert data to MySQL with auto-incremented column(field)?
  15. How to insert values in table with foreign key using MySQL?
  16. Field ‘id’ doesn’t have a default value?
  17. MySQL INSERT INTO … VALUES and SELECT
  18. MySQL error 1241: Operand should contain 1 column(s)
  19. insert data from one table to another in mysql
  20. MySQL Insert & Joins
  21. How to add a where clause in a MySQL Insert statement?
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. Mysql insert into 2 tables
  24. MySQL – insert data from another table merged with constants
  25. Insert data into table with result from another select query
  26. MySQL optimizing INSERT speed being slowed down because of indices
  27. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  28. Incorrect integer value: ” for column ‘id’ at row 1
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment