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 possible in SQLite or must I instead insert one at a
> time.


One INSERT command = one new record.

Depending on what part of the API you're using, you may be able to  
string multiple INSERT commands together, separated by a semi-colon.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to