On 2/9/16, Clemens Ladisch <clemens at ladisch.de> wrote: > Chris Prakoso wrote: >> insert into test (field1,field2) values (1,"two"),(2,"three") >> >> SQL Error: near ",": syntax error > > You might want to update to a tool that is not years out of date. >
What Clemens means by this is that prior to SQLite 3.7.11 (2012-03-20) the INSERT statement would only take a single row in the VALUES clause. He is suggesting that you are using a version of SQLite that is 4 year old or older and therefore lacks this feature. -- D. Richard Hipp drh at sqlite.org