On Mon, Jan 13, 2014 at 12:21 PM, big stone <[email protected]> wrote:
> 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);
> ....
>
Are you talking about code in the test scripts?
>
> 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 supports it too. And, in fact, you'll find both forms in the test
scripts:
INSERT INTO t1 VALUES(1); INSERT INTO t1 VALUES(2);
And
INSERT INTO t1 VALUES(1),(2);
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
