I did a test using simple table, and entering the sql directly using SQLite Administrator:
*insert into test (field1,field2) values (1,"two"),(2,"three")* The error I got from the SQLite Administrator is: *2/9/2016 11:29:40 AM: SQL Error: near ",": syntax error <insert into test (field1,field2) values (1,"two"),(2,"three")>* Thanks, Chris On Tue, Feb 9, 2016 at 11:55 AM, Richard Hipp <drh at sqlite.org> wrote: > On 2/9/16, Chris Prakoso <chris at prakoso.net> wrote: > > Hi Clemens, > > > > Thanks for your reply. I've tried to use raw SQL but it didn't work > > either. > > Please show us the SQL that you did you. > > > Do you have any SQLite front-end that you use? > > > > The only supported "front-end" (if I correctly understand your > meaning) is the command-line tool "sqlite3.exe" available from the > https://www.sqlite.org/download.html page. There are many other > third-party tools, most of which are GUI-based. You can use them if > you want, and they usually work quite well, but occasionally have > bugs. > > -- > 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 >