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