> Brass Tilde wrote: > > sqlite> select last_insert_rowid() from Author; > > 5 > > 5 > > 5 > > 5 > > 5 > > > > There are five rows in the table Author. One row > of the result set is generated for each row in the > table. Thus you have 5 rows of output. This is > as designed.
I wondered about that. Thanks for confirming. > You probably meant to say: > > select last_insert_rowid() > > That is, without the FROM clause. And as long as I do that immediately after inserting to the table, with no intervening inserts to other tables, I suspect that will work. Fortunately, I have the luxury of writing a single user, single threaded app. Thanks again.