Re: last_insert_id()

[Vivek Khera]

>>>>> "PB" == Peter Bojkov <peter@stripped> writes:

PB> Hi:
PB> I have a table with approx. 10 mln. rows. I am trying to do a
PB> "select last_insert_id() from table" and mysql returns me 10 mln.

Try "select last_insert_id()" instead.  You requested it to return the
function last_insert_id() for *each* row in your table, rather than
the value of last_insert_id() as a stand-alone function, which it is.