"Justin Lolofie" <[email protected]> wrote in message news:[email protected] > Is there syntax to do multiple row insert? Something like: > > insert into my_table (a,b,c) values ((1,2,3),(4,5,6)); > > The documentation for INSERT seems to imply this is not possible.
Well, you could do something like this: insert into my_table(a, b, c) select * from (select 1, 2, 3 union all select 4, 5, 6); Though it's not clear why you can't just issue a plain vanilla INSERT VALUES statement once for each row. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
