When using the SQL query CREATE TABLE test ( test_1 INTEGER PRIMARY KEY NOT NULL AUTOINCREMENT );
or CREATE TABLE test ( test_1 INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT ); I will get the same error. On Fri, Aug 3, 2012 at 12:46 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Fri, 3 Aug 2012 10:08:56 -0300, Brandon Pimenta > <brandonskypime...@gmail.com> wrote: > > >I cannot use AUTO_INCREMENT. Here's my query: > > > >CREATE TABLE test ( > >test_1 NOT NULL AUTO_INCREMENT > >); > > > >Running this query gives me "SQL error: near "AUTO_INCREMENT": syntax > >error". What does this mean? > > The keyword is AUTOINCREMENT, without underscore. > It will only work on INTEGER PRIMARY KEY columns. > > http://www.sqlite.org/lang_createtable.html > > > -- > Regards, > > Kees Nuyt > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
