Re: [sqlite] Unexpected results from SQLite3.exe

[D. Richard Hipp]

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.
You probably meant to say:
    select last_insert_rowid()
That is, without the FROM clause.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565