How to get inserted row IDs for bulk/batch insert with wpdb query?

As described here:

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.

So if you need every inserted ID you should use single $wpdb->insert commands, then you have the ID available for each with $wpdb->insert_id. Docs here: https://codex.wordpress.org/Function_Reference/wpdb_Class#INSERT_row

If you insert many rows with a single query you can’t get all the inserted ID’s, unless you e.g. wanted to re-query for them if you are sure you can identify those rows uniquely.

Related Posts:

  1. Is it mandatory to use $wpdb->prefix in custom tables
  2. WordPress and multithreading
  3. Actions or filters fired when data is saved in a custom table
  4. Custom Plugin Database relations
  5. Activation hook not creating table
  6. Get a custom table to an array
  7. How to create database table, add data, update and delete using wpdb via plugins?
  8. Using WPDB to output raw XML fails because of wp-blog-header.php
  9. wpdb->prepare and mysql UPDATE – how is it done?
  10. $wpdb->update Issue
  11. WordPress database error: [Query was empty] – using $wpdb->prepare()
  12. bindParam? WordPress 4.9.5 SQL LIKE statement %s and %LIKE%
  13. Update database record in plugin
  14. WordPress plugin tables become corrupt
  15. Can I log the searches that are returning 404 in the DB?
  16. multiple record insert creating many duplicate records
  17. Post meta vs separate database tables
  18. get_results using wpdb
  19. Using query_vars filter
  20. Using a database view = evil incarnate?
  21. Check for success of $wpdb->update() correctly
  22. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  23. Export wordpress table to excel
  24. How is the data stored in the database?
  25. $wpdb->insert is changing a value
  26. Retrieving custom fields with $wpdb->get_results
  27. Sample — test — data for large WordPress install
  28. Is there any reason only 1 (my) IP would be added to this table using $wpdn->insert?
  29. why creating tables using $wpdb is not being executed while installing plugins?
  30. How to use mysql IN statement with wpdb update method?
  31. How to store data for posts/pages built with drag-n-drop builder?
  32. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  33. Creating table with plugin is not working
  34. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  35. dbDelta() Error – Incorrect index name ” for query ALTER TABLE
  36. Update/insert only a column of database table
  37. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  38. Where to store the name of a custom table?
  39. include wp-blog-header not working on MAMP
  40. WordPress database error for query INSERT INTO
  41. How to connect to AWS RDS external database (not for the core WordPress db)
  42. SQL query for custom taxonomy slugs
  43. Issue regarding $wpdb->prepare()
  44. Select two sums with single get_var statement
  45. Error on inserting a form value to database
  46. Strange issue saving custom field data for a WooCommerce order
  47. how to search users by ajax live search
  48. Form doesnt save to database
  49. Adding custom end points, No error line
  50. Intermittent database errors when accessing WordPress database
  51. Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
  52. Storing data in wordpress database from ajax call from different website
  53. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  54. $wpdb->replace: WHERE?
  55. Admin Posts List (edit.php) by post IDs
  56. plugin code is pulling information from database in one instance and not in other. What is wrong?
  57. Optimising a big WordPress site
  58. dbDelta SQL Query Not Working
  59. wp_get_post_terms Order by not working
  60. What is the best way to store a few fields?
  61. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  62. $wpdb->query can’t insert data
  63. Custom WordPress Table wpdb
  64. Best practice to limit results in get_row()?
  65. Make Database query only when option is updated
  66. Can we intercept user_login and user_pass from a wp_login_form?
  67. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  68. Data inserted by wpdb insert is different than data pressnt in database.
  69. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  70. How do I debug an error that a plugin is causing?
  71. $wpdb in php 5.5
  72. Update plugin settings option_name for big plugin update
  73. select a single val though a table in wordpress
  74. Plugin to create Posts and Forums then choose category and parent forum
  75. Checking for existing title in custom db query not working
  76. Why doesn’t my Table get created?
  77. How to display specific data from a custom table to logged in users with a custom role
  78. $wpbd->insert_id is returning null
  79. How to insert a value to decimal type field using wpdb->prepare?
  80. Does this archive template part look like its making too many calls to the db?
  81. How to grab data after wp user search is complete
  82. How to securely controlling data without keeping it in postmeta?
  83. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  84. woocommerce add a new bulk action in the bulk actions dropdown in the orders list
  85. Save in my custom admin page and redirect to the saved object
  86. Relational / Associate tables using native WordPress functionality
  87. WordPress doesn’t create table on plugin activation
  88. How and when would I implement some code which would take data from one part of the Db and put it in another?
  89. WP Query Relations / Compare
  90. How to CRUD from wordpress database in wordpress theme?
  91. Should I Use only wpdb Class to Write Custom Queries?
  92. I can’t write in my DB using $wpdb->insert
  93. Why Worpdress doesn’t create table in database?
  94. Form and database, plugin development
  95. wpdb get_results() returns only 2 rows
  96. Pulling values from a sepcific row in table
  97. Nothing happens on WordPress Update command
  98. Running one-off cron jobs when WP_DISABLE_CRON is true: can I hit /wp-cron.php?
  99. Leveraging Core Functionality in Icon Upload Plugin [closed]
  100. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]