Look at the <u>[RETURNING clause](https://sqlite.org/lang_returning.html)</u>. Or, for versions of SQLite too old to support RETURNING: <code> create table EverMore(id integer primary key, stuff text); insert into EverMore values (null, 'One'); select last_insert_rowid() as id; </code>