MySQL – how many rows can I insert in one single INSERT statement?

by

You can insert infinitely large number of records using INSERT ... SELECT pattern, provided you have those records, or part of, in other tables.

But if you are hard-coding the values using INSERT ... VALUES pattern, then there is a limit on how large/long your statement is: max_allowed_packet which limits the length of SQL statements sent by the client to the database server, and it affects any types of queries and not only for INSERT statement.

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  3. Count the occurrences of DISTINCT values
  4. Codeigniter – multiple database connections
  5. Column count doesn’t match value count at row 1
  6. How to add levenshtein function in mysql?
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. How do I modify a MySQL column to allow NULL?
  10. Connect to mysql in a docker container from the host
  11. Is there ANY_VALUE capability for mysql 5.6?
  12. Set NOW() as Default Value for datetime datatype?
  13. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  14. SQL DELETE with JOIN another table for WHERE condition
  15. How to connect to a MySQL Data Source in Visual Studio
  16. DOs and DONTs for Indexes [closed]
  17. MySQL treats ÅÄÖ as AAO?
  18. How can write queries in MySQL that can parse JSON data in a column?
  19. Count with IF condition in MySQL query
  20. MySQL Time Zones
  21. How to use django models with foreign keys in different DBs?
  22. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  23. Mysql select where not in table
  24. Using DISTINCT and COUNT together in a MySQL Query
  25. Which DATATYPE is better to use TEXT or VARCHAR?
  26. MySQL vs. JSON – Why? [closed]
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment