Limit on inserting multiple rows

Question

Starting with version 3.7.11, SQLite supports the extended INSERT syntax, which allows you to insert multiple rows through the VALUES clause.

http://www.sqlite.org/releaselog/3_7_11.html

Is there a limit on the number of values ​​that can be inserted into a single statement? (e.g. 500).

Answer 1

SQLite treats multi-line INSERT as a compound SELECT. The limit for this is really 500 .

However, since version 3.8.8 ,

the number of rows in the VALUES clause is no longer limited to SQLITE_LIMIT_COMPOUND_SELECT.

Answer 2

According to the official documentation, there are actually some limitations:

• Maximum SQL Statement Length

  The maximum number of bytes in the text of an SQL statement is limited by SQLITE_MAX_SQL_LENGTH, which by default is 1,000,000 bytes .

• Maximum number of host parameters in a single SQL statement

  The number of host parameters (like tokens) - either named, unnamed, or numbered - is limited by SQLITE_MAX_VARIABLE_NUMBER, by default - 999 elements .