Take the 2-minute tour ×  I want to insert thousand of Record in
table, right now i am using  INSERT INTO myTable ("id",
"values") VALUES ("1", "test") INSERT INTO myTable ("id",
"values") VALUES ("2", "test") INSERT INTO myTable ("id",
"values") VALUES ("3", "test")  Query for insert record one by
one, but its take long time for execution,  Now i want to insert
all record from one query...   ("1", "test"),  ("2", "test"),
("3", "test"),  ("n", "test")  But this query not working with
Sqllite, Can you please give me some guidance for solve this
problem   share|improve this question This query is supported
now. –  mjb May 16 '13 at 16:24  4 Answers 4  up vote 4 down
vote accepted  Insert into table_name (col1,col2) SELECT
'R1.value1', 'R1.value2' UNION SELECT 'R2.value1', 'R2.value2'
UNION SELECT 'R3.value1', 'R3.value2' UNION SELECT 'R4.value1',
'R4.value2'  share|improve this answer refer this link for ur
perusal –  itechnician Jun 25 '12 at 11:36 Also the above query
works now in ios 7 –  itechnician Oct 8