lundi 28 septembre 2015

Is there a row limit when using a SQLite's INSERT INTO with SELECT query?

I'm attaching a database (B) to another database (A) and trying to populate an empty table in A by doing something like:

INSERT INTO table SELECT * FROM B.table

SQLite's documentation mentions this, but it doesn't mention any limit on the number of rows returned by the SELECT statement (or processable by an INSERT statement in this particular scenario).

Is there any limit on this number of rows, or can I assume that all rows return by the SELECT query will indeed be inserted? (please note that I'm not looking for alternative ways of copying the data, I really just want to know whether or not I may bump into any unexpected limits here)

Aucun commentaire:

Enregistrer un commentaire