Multiple Inserts with SQLite

[lintz]

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?

INSERT INTO TableName (col1,col2) 
values(val1,val2),
(val3,val4),
(val5,val6)

[si_the_geek]

That method is unusual, most database systems only allow you to use a Select statement, eg:

INSERT INTO TableName (col1,col2) 
SELECT col, col2
FROM OtherTable