How to do a batch insert in MySQL

by

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);

More Related Contents:

  1. How do I get the ID of multiple inserted rows in MySQL?
  2. How to insert data to MySQL with auto-incremented column(field)?
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. How to select the nth row in a SQL database table?
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. Error Code: 2013. Lost connection to MySQL server during query
  7. Storing JSON in database vs. having a new column for each key
  8. How do I restore a dump file from mysqldump?
  9. Using an Alias in SQL Calculations
  10. Can a table field contain a hyphen?
  11. Adding a leading zero to some values in column in MySQL
  12. View’s SELECT contains a subquery in the FROM clause
  13. Check for x consecutive days – given timestamps in database
  14. MySQL Insert Into from one Database in another
  15. Does mysql have the equivalent of Oracle’s “analytic functions”?
  16. Case statement in MySQL
  17. MySQL INSERT INTO … VALUES and SELECT
  18. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  19. Remove special characters from a database field
  20. Using reserved words in column names
  21. MySQL query, MAX() + GROUP BY
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. How to get multiple records against one record based on relation?
  24. MySQL – Replace Character in Columns
  25. FIND_IN_SET with multiple value [duplicate]
  26. What is the difference between SQL and MySQL? [closed]
  27. How to use a user variables in MySQL LIKE clause?
  28. Selecting distinct 2 columns combination in mysql
  29. How to store a one to many relation in MySQL database?
  30. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;

Leave a Comment