With mySQL I can use the below to insert many rows at once however I have not been able to do this using SQLite. Does anyone know if it's possible?
Code:INSERT INTO TableName (col1,col2)
values(val1,val2),
(val3,val4),
(val5,val6)
Printable View
With mySQL I can use the below to insert many rows at once however I have not been able to do this using SQLite. Does anyone know if it's possible?
Code:INSERT INTO TableName (col1,col2)
values(val1,val2),
(val3,val4),
(val5,val6)
That method is unusual, most database systems only allow you to use a Select statement, eg:
Code:INSERT INTO TableName (col1,col2)
SELECT col, col2
FROM OtherTable