When i insert more than 500 records into sqlite database, an error "too many terms in compound SELECT" occurs. I have read the details about sqlite limit
Now i want to insert more than 1000 (say 2000 products) records into the database. Can anyone suggest, how to write query to insert more than 1000 records. This requirement is very urgent, Please help me out in solving this issue.
Here is the insert query i have used:
INSERT INTO Product SELECT '4886229673836544' AS productId, 'Pen1' AS productName, '10' As sellingPrice UNION SELECT '4780676557570048', 'Pen2', '10'........... UNION SELECT '4562973255270400', 'Pen1000', '10'
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire