wpdb->insert multiple record at once

$wpdb->query("INSERT INTO settings-table
            (option_name, option_value, option_created, option_edit, option_user)
            VALUES
            ('name-1', 'val-1', current_time('mysql'), current_time('mysql'), 'user-1'),
            ('name-2', 'val-2', current_time('mysql'), current_time('mysql'), 'user-2'),
            ('name-3', 'val-3',  current_time('mysql'), current_time('mysql'), 'user-3')")

In the query which you had posted, the column names shouldn’t be in string.

Related Posts:

  1. Using wpdb to connect to a separate database
  2. How to fetch Data in WordPress using MySQLi or $wpdb
  3. How to define composite keys with dbDelta()
  4. Inserting Post Meta From SQL
  5. Why does dbDelta() not catch MysqlErrors?
  6. What causes the “max_user_connections” warning on WordPress frontend?
  7. How to execute mulitple statement SQL queries using $wpdb->query?
  8. Database slowdown after update to 3.4.1
  9. wpdb_prepare with multiple or condition
  10. WordPress database error – Error in SQL syntax – I can’t identify any error?
  11. Advanced SELECT query with condtional statements
  12. Redirecting to old domain after migration website
  13. Create table from array with prepare
  14. WordPress running SQL query to update database from form
  15. Have working sql query… trying to adjust it to use $wpdb
  16. Custom WordPress Table wpdb
  17. Best practice to limit results in get_row()?
  18. Trouble running $wpdb->query() with last_insert_id
  19. Query Column of Specific ID from Database Table
  20. How to create more than one new wpdb object?
  21. How to connect and insert data in database of wordpress?
  22. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  23. “BS_” rows in postmeta table
  24. Where is the HTML-handler part in the wpdb class?
  25. WordPress Database Query works in phpMyAdmin but not in the code
  26. insert data from a form:: Warning Empty query mysqli::query()
  27. How can I get $wpdb to show MySQL warnings?
  28. How To connect to the same WordPress database with different database user
  29. using same mysql user with many databases
  30. Uploading to WordPress Database
  31. MySQL Database User: Which Privileges are needed?
  32. Will it break my site if I delete all transient records in wp_options table?
  33. Please explain how WordPress works with MySQL character set and collation at a low level
  34. Detecting errors generated by $wpdb->get_results()
  35. wpdb update add current timestamp not working
  36. Restoring WordPress posts from database only
  37. Slow wp_term_relationships query
  38. How might I retrieve a featured post image from an external WP site and display it as a link back?
  39. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  40. How to close wpdb connection? [duplicate]
  41. What are conventions about the schema of the $table_prefix
  42. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  43. Is deleting orphaned wp_options entries safe?
  44. How to solve slow WordPress site caused by attachment_metadata
  45. Delete all post meta except featured image
  46. WooCommerce – Query for ordered products
  47. Large database causes slow load
  48. Safe way to find last inserted id in a table?
  49. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  50. Tons of Twitter rows in my database
  51. How to insert data into MySQL database from the form created in WordPress site
  52. Select Multiple meta_value from WP DB; Single Query
  53. Multiple postmeta with same name for one post in wp_postmeta table
  54. Which is more efficient? Using usermeta, or creating a new MySQL table?
  55. What happens if I overwrite the current wp_options table with a backup from a week ago?
  56. CRUD operations using WordPress database API
  57. Modify Database in Multi-Site wp_usermeta table
  58. $wpdb doesn’t like to store arrays
  59. Handling large N data in WordPress
  60. How to Mirror WordPress database from Remote server to Local server
  61. Update results, Before deleting the related category [closed]
  62. A MySQL DB within a MySQL DB
  63. Is there a way to recover the table wp_term_relationships?
  64. Trouble Migrating all data blog from WordPress.com to WordPress.org
  65. How Can I Put Meta_Compare in the Database-Query?
  66. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  67. $wpdb error (Call to a member function insert() on a non-object)
  68. Is it important to have integers inserted using %d rather than %s?
  69. I can’t update my data through $wpdb
  70. Using $wpdb | checking entered email against existing emails in db
  71. Moving WordPress site to new domain – database import [duplicate]
  72. Get results from wordpress data custom table
  73. Outputting query results
  74. Add row to custom database Table and delete all rows older than 1 day
  75. add_post_meta — not working
  76. Select From wpdb – Author/User Directory page
  77. WordPress database error: [Query was empty] – using $wpdb->prepare()
  78. $wpdb->insert not inserting all rows
  79. SELECT rows between two datetimes when the range is dynamic [closed]
  80. Insert NULL value using prepare()
  81. How can I find user role in Mysql?
  82. $wpdb->insert duplicating rows
  83. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  84. Featured image from custom to WordPress database
  85. Delete all users meta that named: user_avatar
  86. Correct and secure way to access a custom SQL database in a custom PHP template file
  87. Using $wpdb to insert data into a table
  88. spambot registering without providing email or password, bypassing registration process
  89. Possible to restore wordpress database from mysql56 and sqlite files?
  90. Missing latest posts and options after DB migration via phpMyAdmin
  91. Processing a lot of $wpdb isn’t insert all the data
  92. Widgets with *internal* links do not display after database migration
  93. How do i get value from wp_postmeta?
  94. “MySQL server has gone away” since update to 3.8
  95. featured image not showing up with mysql_connect
  96. How to use remote db tables in current config? [duplicate]
  97. Importing Concrete5 content to WordPress
  98. why you don’t Implement PDO for access every thing to database
  99. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  100. Have WordPress Use a Different Database for users

Leave a Comment