Hi 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 <https://www.sqlite.org/limits.html>.
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. 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' -- You received this message because you are subscribed to the Google Groups "AngularJS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/angular. For more options, visit https://groups.google.com/d/optout.
