Simon Slavin writes: > > On 19 Dec 2011, at 7:04am, YJM YAN wrote: > > //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.
If I am reading that page correctly, AUTOINCREMENT is not permitted in this context. Is that right? Or are the diagrams incomplete in this? (I will admit that it doesn't really make sense for a multi-column constraint.) --David Garfield _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
