On Mon, Nov 25, 2013 at 2:18 PM, L. Wood <lwoo...@live.com> wrote: > I have my own whateverId column of type INTEGER PRIMARY KEY AUTOINCREMENT. > > Does AUTOINCREMENT change anything? > > * Is whateverId still just an alias for the built-in rowid (as it would be > without the AUTOINCREMENT)? > > * Does sqlite3_last_insert_rowid() return the whateverId of the last > INSERTed row, as I would expect? > > Testing says...
[stephan@host:~]$ sqlite3 sqlite> create table t(x INTEGER PRIMARY KEY AUTOINCREMENT); sqlite> insert into t(x) values(NULL); sqlite> select last_insert_rowid(); 1 sqlite> select rowid from t; 1 -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
