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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
