[sqlite] Insert multiple entries in a single INSERT statement

Hello, Looking at the SQL syntax chart it doesn't seem like this is possible. In other SQL servers I'm able to use the statement "insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3', '3');". Is this possible in SQLite or must I instead insert one at a time. -Sh

Re: [sqlite] Insert multiple entries in a single INSERT statement

On Tue, 28 Jul 2009 14:22:28 -0400, "Shaun Seckman (Firaxis)" wrote: >Hello, > >Looking at the SQL syntax chart it doesn't seem like >this is possible. In other SQL servers I'm able to use the statement >"insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3', >'3');"

Re: [sqlite] Insert multiple entries in a single INSERT statement

} return $numInserted; } -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Tuesday, July 28, 2009 2:22 PM To: General Discussion of SQLite Database Subject: [sqlite] Insert multipl

Re: [sqlite] Insert multiple entries in a single INSERT statement

On Tue, 28 Jul 2009, Shaun Seckman (Firaxis) wrote: > Looking at the SQL syntax chart it doesn't seem like this is possible. > In other SQL servers I'm able to use the statement "insert into > foo('col1', col2') values ('1', '1'), ('2', '2'), ('3', '3');". Is this > possible in SQLite or must

Re: [sqlite] Insert multiple entries in a single INSERT statement

return undef; } else { $errorMessage = undef; } return $numInserted; } -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Tuesday, July 28, 2009 2:22 PM To: General Di

Re: [sqlite] Insert multiple entries in a single INSERT statement

On 28 Jul 2009, at 7:22pm, Shaun Seckman (Firaxis) wrote: >Looking at the SQL syntax chart it doesn't seem like > this is possible. In other SQL servers I'm able to use the statement > "insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3', > '3');". Is this possibl

Re: [sqlite] Insert multiple entries in a single INSERT statement

Kees Nuyt wrote: > > > Insert one row at a time. > > > Presumably you can do this kind of thing: INSERT INTO Table2 ( [FieldX] ) SELECT FieldY FROM Table1; -- View this message in context: http://www.nabble.com/Insert-multiple-entries-in-a-single-INSERT-statement-tp24705205p24737715.html