How to do a batch insert in MySQL

From the MySQL manual

INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. How do I restore a dump file from mysqldump?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. 1052: Column ‘id’ in field list is ambiguous
  6. difference between primary key and unique key
  7. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  8. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  9. Case statement in MySQL
  10. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  11. Cannot delete or update a parent row: a foreign key constraint fails
  12. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  13. How do I quickly rename a MySQL database (change schema name)?
  14. What does SQL Select symbol || mean?
  15. What is the definition of cardinality in SQL
  16. When to use SELECT … FOR UPDATE?
  17. Error Code: 2013. Lost connection to MySQL server during query
  18. How to join two tables by multiple columns in SQL?
  19. How to get size of mysql database?
  20. mysql Foreign key constraint is incorrectly formed error
  21. Selecting data from two different tables without using joins
  22. how to drop partition without dropping data in MySQL?
  23. MySQL: Invalid use of group function
  24. Creating a search form in PHP to search a database?
  25. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  26. MySQL Error 1264: out of range value for column
  27. Simple Random Samples from a Sql database
  28. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  29. What does SQL clause “GROUP BY 1” mean?
  30. LAST_INSERT_ID() MySQL
  31. Generating a random & unique 8 character string using MySQL
  32. SQL select only rows with max value on a column
  33. SQL statement not working – “Operand type clash: date is incompatible with int’
  34. Convert partially non-numeric text into number in MySQL query
  35. Repair all tables in one go
  36. MySQL equivalent of DECODE function in Oracle
  37. How can I search (case-insensitive) in a column using LIKE wildcard?
  38. How to create a foreign key in phpmyadmin
  39. Get the new record primary key ID from MySQL insert query?
  40. importing a CSV into phpmyadmin
  41. How to copy a row and insert in same table with a autoincrement field in MySQL?
  42. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  43. Solutions for INSERT OR UPDATE on SQL Server
  44. Remove Primary Key in MySQL
  45. MySQL: Cloning a MySQL database on the same MySql instance
  46. Is merge statement available in MySQL
  47. What SQL Query to do a simple find and replace
  48. What’s a good strategy for planning WordPress DB growth?
  49. Scanning Database for malicious Data
  50. wpdb->prepare function remove single quote for %s in SQL statment
  51. How to Join two tables from separate databases within WordPress
  52. Extending the database
  53. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  54. How to execute mulitple statement SQL queries using $wpdb->query?
  55. Query WordPress database by registered date and role
  56. wpdb_prepare with multiple or condition
  57. How do I find which articles are missing a featured image in The WordPress database?
  58. SQL Error wp_commentmeta – incorrect table definition
  59. How to find meta entries with their posts missing via SQL?
  60. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  61. How do I get the posts within a certain year/date(with sql query)?
  62. Database Tables Lost Indexes? How to Recover?
  63. SQL Database, repeated tables?
  64. Create table from array with prepare
  65. Code to remove authors with no posts connected to them
  66. Which is better and faster ? WordPress Queries or SQL Query
  67. SQL Query in WordPress – Getting Impossible WHERE error
  68. Why this query is not showing any result on wordpresss home page?
  69. Using AND and bracket grouping in SQL not working
  70. How to get INSERT errors from $wpdb?
  71. SQL query to set posts in bulk based on the post content
  72. MySQL query for taxonomy-meta
  73. How can I write a formal sql query to get data from a custom table
  74. latency problems with wordpress install (from SQL import)
  75. DB prefix not updating
  76. Performing CRUD operations on front end in wordpress
  77. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  78. Find locations of all featured images of draft posts via SQL
  79. SQL query to change custom field in WordPress database
  80. Bulk find & replace on WordPress posts/pages (minus image paths)
  81. How to show result of sql query in a page?
  82. update_option returns false in AJAX, how to debug?
  83. How to create index (sql) to a meta_key?
  84. Improving performance of SQL sub-queries in WordPress
  85. The function is deprecated; use mysql_real_escape_string() instead
  86. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  87. WPDB delivers wrong results from complex queries
  88. How to change link in all posts?
  89. Display MySQL as part of a Page
  90. Query sql for truncate post_content in wp_posts table
  91. Woocommerce: Grab total revenue of a product over all orders
  92. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  93. Delete posts with word count less than x number of words
  94. SQL query : Select a thumbnail for a media
  95. SQL – Pull products of particular category from a remote WordPress woocommerce db
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  98. SQL get last entry of a specific gravity form
  99. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment

tech