The maximum number of data inserted in the Sqlite database is 500, and the maximum number of sqlite data inserted

The maximum number of data inserted in the Sqlite database is 500, and the maximum number of sqlite data inserted

When inserting data into the Sqlite database today, the following error is reported:

Copy codeThe Code is as follows:
"Too shortterms in compound SELECT"

I checked it on Stackoverflow and found someone answered this question: Link

The number of data records inserted into the database at one time cannot be too large, and the maximum is 500. An error is returned if the number exceeds the limit.

The solution is to insert the database multiple times.