SoFunction
Updated on 2025-04-08

The upper limit of the number of data inserted in the Sqlite database is 500

Today, when I was inserting data into the Sqlite database, I reported this error:

Copy the codeThe code is as follows:

"too many terms in compound SELECT"

I checked on * and found someone answered this question: Link

It turns out that the number of data inserted into the database at one time should not be too many, the upper limit is 500. If it exceeds the problem, an error will be reported.

The solution is to insert the database into several times.