On 07/27/2014 12:07 PM, michael walsley wrote: > Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value > on insert is not null it doesn't get a new rowid, it just accepts the value > as in the insert?
sqlite> create table t(x integer primary key autoincrement); sqlite> insert into t(x) values(42); sqlite> select * from t; 42 What is your app actually doing? Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
