How to insert multiple postmeta values with one query?

You can’t insert multiple rows via wpdb’s insert, you have to do it with raw SQL:

INSERT into $meta_table (post_id, meta_key, meta_value) 
VALUES
('val1', 'val2', 'val3'),
('otherval1', 'otherval2', 'otherval3')

However-

You should always use the API where a function exists- use add_post_meta so your plugin integrates with the WordPress environment and its behavior can be modified without having to edit the plugin’s files directly.

Related Posts:

  1. Comparisson between date() and a date from wp_postmeta
  2. any word search WordPress
  3. How to securely controlling data without keeping it in postmeta?
  4. Performance considerations – postmeta table versus new table for custom posts with foreign keys?
  5. How to fix slow comment query?
  6. Action hook “wp_insert_post” works but not for last imported post
  7. WP JSON REST API (Ryan McCue) how to query posts with specific meta data with ‘AND’ relation?
  8. Creating two database tables via plugin
  9. Query Posts by Custom Field ‘Price’
  10. insert data in database table from plugin with WP3.1
  11. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  12. ob_end_flush error when using wpdb in plugin
  13. Thumb rating for wordpress – top user
  14. Show the “ratingValue” and “ratingCount” values ​of KK Star Ratings Plugin
  15. How to extract images of post and pages excluding header and logo image in wordpress?
  16. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  17. Fatal error: Uncaught Error: Call to undefined function get_userdata()
  18. Set attached to state
  19. How use %like% in sql statement wordpress
  20. WordPress logo upload option in theme panel
  21. Inserting large amounts of data into a custom table during plugin install
  22. FacetWP group listings by custom field [closed]
  23. Where to hook my plugin’s action
  24. Is there a filter for get_post_custom()?
  25. how do i remove posts from a WP_Query so the pagination is right?
  26. Is Wrapping intval() Around esc_attr() Redundant for Escaping Input?
  27. Accessing post’s meta data based on user’s click of a post
  28. Get posts from WP_Query and format them on admin_head
  29. Doubt using $wpbd->get_col for a single column
  30. How to query the custom fields by language?
  31. Access WordPress database outside of WordPress
  32. Create digital-virtual-downloadable WooCommerce products from the frontend using Gravity Forms? [closed]
  33. switched from query_posts to WP_query, not working now?
  34. Problem with creating tables for Plugin
  35. How to display the “ratingValue” and “ratingCount” values ​generated by the KK Star Ratings plugin into my page’s recipe ld+json schema
  36. How to change this WP_Query to get all ProductIDs and not only specific one?
  37. Change commission_status paid when withdraw_status vendor is completed
  38. How to call WordPress function other files
  39. Insert content of a post into another
  40. WP_Query and NULL meta keys
  41. $wpdb->get_row returns column name instead of column value
  42. how to use in custom single.php template using php?
  43. How can I change the meta_key for a particular piece of information?
  44. Create a table with wordpress plugin boilerplate
  45. WordPress page and plugin list using sql query
  46. Using AJAX to generate front end / viewer end pages
  47. plugin code is pulling information from database in one instance and not in other. What is wrong?
  48. WooCommerce search products between price range using WP_Query
  49. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  50. Meta box losing its value when scheduled post is published
  51. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  52. Cannot get wpdb data (Error in a simple fuction) [closed]
  53. WPDB: Update table
  54. How to Loop Through all Posts and Count Attachments using Get Media Attachments
  55. Error in pdf generating plugin using FPDF
  56. How to remove bulk actions from custom post type
  57. Return multiple values ​in a shortcode attribute
  58. How to select a paragraph other than the 1st to be the post’s excerpt?
  59. Loop returns the current page’s permalink and guid instead of the post in the loop
  60. How to get CPT category checkbox list and show post of selected(multiply) checkboxes via ajax?
  61. BuddyPress activity on edit post for a CPT
  62. Displaying data from another database
  63. Using $wpdb in a plugin, what sort of data does it return?
  64. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  65. Link Posts to External URL
  66. How to find the WordPress Nextgen galleries which are not used in WordPress posts?
  67. Adding CASE in WP_Query
  68. Need help creating asynchronous data scraper in WordPress
  69. Woo-commerce Update price as a Bulk from My offline software export
  70. Trying to get property ‘ID’ of non-object in /wp-includes/class-wp-query.php on line 4044
  71. ob_end_flush(): failed to send buffer of zlib output compression (0) in external php
  72. Help to Create a Simple Plugin to make a post
  73. how to display recent post by category on home page
  74. How to Join wp_posts & wp_postmeta table using custom query
  75. What database state changes happen after a post is manually “updated” with no changes?
  76. $wpdb->delete not working for me
  77. Warning: call_user_func_array() problem can anyone help with it?
  78. Fatal error: Uncaught Error: Cannot use object of type WP_Error as array in /../plugins/rm-payment.php
  79. “Enable Media Replace” plugin does not update serialized object in WPMeta
  80. No result after wpdb->insert
  81. How to get post that has non zero or greater than zero meta value
  82. How to insert variable which contain array value in wp_options table?
  83. Trending Tags based on post views
  84. Plugin does not create a custom table upon activation
  85. Proper way to trigger a MySQL query via link in a plugin
  86. get_var result empty for query of custom table in plugin admin
  87. Storing values in Post Meta vs new tables
  88. WordPress filter function using query modifications
  89. WP-Snap too slow (caused by WP_Query?)
  90. WordPress Meta Query: Relation is not working correctly
  91. WordPress ultra slow if I click on posts?
  92. Insert data in custom table during new post creation
  93. Checking url from plugin [duplicate]
  94. Making plugin to use different table prefix cause permission problem
  95. Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
  96. Output plugin post like system count [closed]
  97. $wpdb selects wrong database
  98. FATAL ERROR: WP complains about redeclaration [closed]
  99. Update post meta Rest Api
  100. how to add meta for order in woocommerce
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedusedueduedusedusedusedueduedu