[sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

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

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

On 1/13/14 9:21 AM, "big stone" 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); > > >Wouldn't it be both an economy of coding time and a more quick upload

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

On 13 Jan 2014, at 5:21pm, big stone wrote: > 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), (); That does actually work. See the syntax diagram at

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

On Mon, Jan 13, 2014 at 12:21 PM, big stone 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? > >

Re: [sqlite] Insert multiple values as an economy of coding time and quicker upload process ?

Yes, I was talking of the very test script that were written last friday : [a26f399ba4] like : do_execsql_test 4.1 { DROP TABLE IF EXISTS t1; CREATE TABLE t1(x); INSERT INTO t1 VALUES(1); INSERT INTO t1 VALUES(2); INSERT INTO t1 VALUES(3); INSERT

[sqlite] Best method for a multi-thread application

Please note, if you'd like to discuss this program as an entity outside this thread, feel free to contact me directly. I think my email address is exposed in this thread. I'm writing a new program** to keep track and manage my MP3s and will allow me to sync different sets of MP3s to different

[sqlite] shell crashes when there is no column name

Hi, the shell does not always check the return value of sqlite3_column_name() for being NULL: $ sqlite3 SQLite version 3.8.3 2014-01-11 12:52:25 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .header on sqlite> values(1); (null) 1 sqlite>

Re: [sqlite] Generating sqlite4.c

Yes, for sure. On Wed 08 Jan 2014 03:02:20 PM EST, big stone wrote: Will you write a small result of your early experiment ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users