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

On Tue, 28 Jul 2009 14:22:28 -0400, "Shaun Seckman
(Firaxis)" <Shaun.Seckman@xxxxxxxxxxx> 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');".  Is this possible in SQLite or must I instead insert one at a
>time.

Insert one row at a time.
-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users