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. Delete data from database using row action
  18. Show dynamic list of products from custom api of another database under same host
  19. WPDB: Update table
  20. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  21. Issue running db create table query from static method
  22. $wpdb->prepare with LIKE and sprintf
  23. Prevent WordPress automatically processing certain URL queries
  24. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  25. $wpdb->query can’t insert data
  26. Custom WordPress Table wpdb
  27. Why in this archive page that call query_posts() function show only the last 10 posts?
  28. insert query on a custom table using ajax with jQuery plugin Jeditable
  29. How to optimize multiple insert into wordpress database
  30. Best practice to limit results in get_row()?
  31. Make Database query only when option is updated
  32. Can we intercept user_login and user_pass from a wp_login_form?
  33. $wpdb->update() always need a second try
  34. How best to handle database version dependence (from $wp_db_version)
  35. WP: Search and replace in DB programmatically
  36. Using AND and bracket grouping in SQL not working
  37. Taxonomy archive page listing terms instead of posts
  38. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  39. Connecting to a different database
  40. Query Column of Specific ID from Database Table
  41. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  42. Data inserted by wpdb insert is different than data pressnt in database.
  43. Proper Prepare Statement for ALTER TABLE and using AFTER
  44. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  45. $wpdb->prepare is not working like mysql_real_escape_string
  46. Brainstorm – Slow Query from Plugin Need to Speed It Up
  47. How to avoid conflicts with db.php / $wpdb and other plugins that decide to use them?
  48. How do I debug an error that a plugin is causing?
  49. Save temporary registration data
  50. $wpdb in php 5.5
  51. Update plugin settings option_name for big plugin update
  52. select a single val though a table in wordpress
  53. Plugin to create Posts and Forums then choose category and parent forum
  54. Checking for existing title in custom db query not working
  55. How to relate the Category to user?
  56. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  57. Why doesn’t my Table get created?
  58. Downloading File via headers doesnt work
  59. Load specific page when a custom URL is hit
  60. How to display specific data from a custom table to logged in users with a custom role
  61. $wpbd->insert_id is returning null
  62. Error code when migrate
  63. How to insert a value to decimal type field using wpdb->prepare?
  64. Does this archive template part look like its making too many calls to the db?
  65. Insert NULL value using prepare()
  66. Why User_login key doesn’t work with wp_update_user()
  67. How to grab data after wp user search is complete
  68. WP_Query not ordering correctly
  69. How to store sensitive user data (passwords)
  70. How to securely controlling data without keeping it in postmeta?
  71. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  72. WordPress Query doesn’t return the correct value
  73. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  74. WordPress Database Query works in phpMyAdmin but not in the code
  75. woocommerce add a new bulk action in the bulk actions dropdown in the orders list
  76. Use admin-post to submit form data to external database
  77. User avatar-ACF fields
  78. Save in my custom admin page and redirect to the saved object
  79. Relational / Associate tables using native WordPress functionality
  80. WordPress doesn’t create table on plugin activation
  81. Insert Data into Database
  82. How to store in the database directly the translation?
  83. How and when would I implement some code which would take data from one part of the Db and put it in another?
  84. WP Query Relations / Compare
  85. pull data from wordpress database
  86. Dedicated server and WPDB Class : huge slow-down of the website
  87. How to implement pagination into a wpdb->result query?
  88. How to CRUD from wordpress database in wordpress theme?
  89. Should I Use only wpdb Class to Write Custom Queries?
  90. Array/List Edit in Backend
  91. Ajax not working to insert, query and result data
  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. How to filter get_adjacent_post()?
  97. Associating special meaning with user id 0
  98. $wpdb how can i save my postmeta table before querying it
  99. Pulling values from a sepcific row in table
  100. What method should I use to store my plugin data (multi level menus with options on each item)
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)