On 3 Aug 2012, at 4:53pm, Brandon Pimenta <brandonskypime...@gmail.com> wrote:
> 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. All INTEGER PRIMARY KEY columns automatically have AUTOINCREMENT. You should not specify it yourself. Also, SQLite will never itself assign a NULL to any of the values. Though I can see that you might want NOT NULL in there to stop it being done by a program which assigns its own value to test_1. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
