2011/8/22 Black, Michael (IS) <michael.bla...@ngc.com>: > sqlite> create table t1(id integer primary key autoincrement,data text); > : > sqlite> select rowid,* from t1; > : > 5|5|two << This should be 4,5 and not 5,5 according to the docs as "3" was > the largest in the table prior to insert.
Column `id` is an alias `rowid`, 3rd paragraph: http://www.sqlite.org/lang_createtable.html#rowid -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users