How do I get the ID of multiple inserted rows in MySQL?

by

  1. You get it via SELECT LAST_INSERT_ID(); or via having your framework/MySQL library (in whatever language) call mysql_insert_id().

  2. That won’t work. There you have to query the IDs after inserting.

More Related Contents:

  1. How to do a batch insert in MySQL
  2. How to insert data to MySQL with auto-incremented column(field)?
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. How to select the nth row in a SQL database table?
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. Storing JSON in database vs. having a new column for each key
  8. How do I restore a dump file from mysqldump?
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. View’s SELECT contains a subquery in the FROM clause
  12. Check for x consecutive days – given timestamps in database
  13. MySQL Insert Into from one Database in another
  14. Does mysql have the equivalent of Oracle’s “analytic functions”?
  15. Case statement in MySQL
  16. Replace Into Query Syntax
  17. MySQL INSERT INTO … VALUES and SELECT
  18. Remove special characters from a database field
  19. Using reserved words in column names
  20. MySQL query, MAX() + GROUP BY
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. MySQL – Replace Character in Columns
  23. FIND_IN_SET with multiple value [duplicate]
  24. Foreign key constraints: When to use ON UPDATE and ON DELETE
  25. What is the difference between SQL and MySQL? [closed]
  26. “Unknown column in ‘field list'”, but column does exist
  27. MySQL: Computed Column
  28. Optimistic locking in MySQL
  29. Insert and set value with max()+1 problems
  30. mySQL SELECT upcoming birthdays

Leave a Comment