Brandon Pimenta <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
