On 19 Dec 2011, at 7:04am, YJM YAN wrote: > //First way create primary key: > CREATE TABLE t(x INTEGER PRIMARY KEY AUTOINCREMENT, y, z); > "x" being an alias for the rowid?
First way will work. > //Second way create primary key: > CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x AUTOINCREMENT)); > "x" being an alias for the rowid? Second way will work too. It correctly declares "x INTEGER" and SQLite understands this. See <http://www.sqlite.org/lang_createtable.html#rowid> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
