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