Igor Tandetnik <itandet...@...> writes: > > "Justin Lolofie" <jta...@...> wrote > in message ... > > 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
Or wrap both (all?) in a transaction if you want atomicity ... MikeW gmane-padding-gmane-padding-gmane-padding-gmane-padding-gmane-padding _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
