> 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.

Reply via email to