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. How to delete all records from or empty a custom database table?
  8. dbDelta only creates the last table
  9. WP JSON REST API (Ryan McCue) how to query posts with specific meta data with ‘AND’ relation?
  10. Creating two database tables via plugin
  11. Query Posts by Custom Field ‘Price’
  12. WP_query parameters for date range
  13. insert data in database table from plugin with WP3.1
  14. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  15. Update Multiple Post Meta for the Same Post In One call?
  16. Stackoverflow type of badge plugin giving warnings in WordPress 3.5
  17. Missing argument 2 for wpdb::prepare() Issue
  18. ob_end_flush error when using wpdb in plugin
  19. Thumb rating for wordpress – top user
  20. Show the “ratingValue” and “ratingCount” values ​of KK Star Ratings Plugin
  21. Updating post meta for custom post types
  22. Find out if request is for custom post type archive before query runs
  23. How to extract images of post and pages excluding header and logo image in wordpress?
  24. How can I add a custom meta value on file upload?
  25. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  26. post_content getting cut off on blank space on $wpdb->update
  27. How to count number of records found in a database table?
  28. How to get custom field image url of specific size
  29. Fatal error: Uncaught Error: Call to undefined function get_userdata()
  30. Is it possible to filter the wp_footer() scripts, read the content, and insert them inline?
  31. Advanced Custom Fields query
  32. How do I add advanced custom fields / meta fields to Elasticsearch? [closed]
  33. Can I run multiple queries with $wpdb->prepare?
  34. Set attached to state
  35. How to change ID of an attachment in wp_posts and its related tables correctly?
  36. Add multiple attributes to product from php
  37. How use %like% in sql statement wordpress
  38. Why am i getting this error? WordPress database error: [Query was empty]
  39. Make the checkbox meta field checked by default
  40. medoo framework in WP plugin
  41. WordPress logo upload option in theme panel
  42. Accessing GET variable named ‘error’
  43. Select from wp_post and multiple meta_value from wp_postmeta
  44. Inserting large amounts of data into a custom table during plugin install
  45. WP_Query ordering numbers as letters
  46. FacetWP group listings by custom field [closed]
  47. Where to hook my plugin’s action
  48. plugin ajax to external php file always return null
  49. Is there a filter for get_post_custom()?
  50. How can i list random post from multiple category?
  51. how do i remove posts from a WP_Query so the pagination is right?
  52. dynamically generating plugin syntax
  53. Is Wrapping intval() Around esc_attr() Redundant for Escaping Input?
  54. Accessing post’s meta data based on user’s click of a post
  55. When to call add_filter
  56. WooCommerce shop page orderby [closed]
  57. w3 total cache and post__not_in
  58. WP_Query Date Filtering Inclusive Being Ignored
  59. Proper way to trigger a MySQL query via link in a plugin
  60. Second foreach loop breaking (Posts2Posts)
  61. Advanced Custom Fields (ACF) Plugin – Random Image in Sidebar
  62. Ger posts from similar tags and categories
  63. get_var result empty for query of custom table in plugin admin
  64. wp_query for more fields plugin
  65. Storing values in Post Meta vs new tables
  66. WordPress filter function using query modifications
  67. wpdb get_var is not returning any result (verified mysql query returns only one value)
  68. WP-Snap too slow (caused by WP_Query?)
  69. WordPress Meta Query: Relation is not working correctly
  70. WordPress ultra slow if I click on posts?
  71. Insert data in custom table during new post creation
  72. Making a Custom Post Type Publish Loop
  73. Include subtitle display to slideshow
  74. Checking url from plugin [duplicate]
  75. Add meta tags with a plugin?
  76. Making plugin to use different table prefix cause permission problem
  77. WordPress User Frontend Editing Custom Fields
  78. wordpress last all added get meta value by post id
  79. Get post id in Post Page within Wp-admin
  80. Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
  81. Output plugin post like system count [closed]
  82. getting image alt text via ACF plugin in WordPress [closed]
  83. Get all the related data from WordPress DB
  84. $wpdb selects wrong database
  85. How to dispaly post informations (such as titles) in an admin plugin menu page?
  86. FATAL ERROR: WP complains about redeclaration [closed]
  87. Update post meta Rest Api
  88. how to add meta for order in woocommerce
  89. I want to display data last 7 days with date wise in chartjs?
  90. How to check record is exist or not in WordPress CRUD Operation with $wpdb
  91. Order custom post type by posts with most likes first
  92. Accessing Correct Database to Create REST API Endpoint
  93. wp db request without refreshing the page
  94. What is the easiest way to create a custom field archive?
  95. How to disable Yoast meta description for all pages
  96. WP_Query does not return the result even if the data is present in the database
  97. Show the author only own types of publications. (JetEngine, Elementor)
  98. Force post update with React
  99. How to filter posts with a wp query by a custom dropdown type field with the magic fields plugin
  100. How to create a dynamically created page on wordpress plugin?