Yes thank you. My SQLite is the latest, it's the front-end that is outdated, which I have just swiftly corrected.
Regards, Chris On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp <drh at sqlite.org> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >