Hello,

I read the source code of sqlite and I find a lot of :


CREATE TABLE t1(x INTEGER);
INSERT INTO t1 VALUES(1);INSERT INTO t1 VALUES(2);
....

Wouldn't it be both an economy of coding time and a more quick upload
process to allow Multiple inserts SYNTAX ?

like :
INSERT INTO t1 VALUES(1),(2), .... (9999);

I'm not 100% certain it's in SQL standard, but the syntax seems ok for
SQL Server , Oracle , and POSTGRESQL at least.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to