Brandon Pimenta <brandonskypime...@gmail.com> wrote: > I cannot use AUTO_INCREMENT. Here's my query: > > CREATE TABLE test ( > test_1 NOT NULL AUTO_INCREMENT > );
First, it's AUTOINCREMENT, without underscore. Second, it can only appear after PRIMARY KEY. > Running this query gives me "SQL error: near "AUTO_INCREMENT": syntax error". > What does this mean? It means that yours is not a syntactically valid SQL statement. The error message seems pretty clear to me. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
