On Nov 29, 2011, at 10:47 AM, Darren Duncan wrote: >> Is it possible to insert multiple rows using a single statement ? > > Yes. > > INSERT INTO foo (x, y) > VALUES (1,2), (3,4), (5,6),...;
I don't think this syntax is supported by SQLite: http://www.sqlite.org/lang_insert.html > > INSERT INTO foo (x,y) > SELECT x, y FROM bar; > > That's at least 2 ways. Additionally, as variation of that option, without a source table (SQLite specific syntax): insert into foo ( x, y ) select 1 as x, 2 as y union all select 3 as x, 4 as y union all select 5 as x, 6 as y _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users