List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:October 27 1999 4:35pm
Subject:Re: last_insert_id()
View as plain text  
>>>>> "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.


Thread
last_insert_id()Peter Bojkov27 Oct
  • Re: last_insert_id()Vivek Khera27 Oct
  • Re: last_insert_id()Tim Endres27 Oct
  • Re: last_insert_id()Name Removed27 Oct
    • Re: last_insert_id()Bob Kline27 Oct
      • Re: last_insert_id()Name Removed27 Oct
        • Re: last_insert_id()Vivek Khera27 Oct
        • Re: last_insert_id()Bob Kline27 Oct
  • Re: last_insert_id()Paul DuBois27 Oct
  • Re: last_insert_id()sinisa27 Oct
  • Re: last_insert_id()Name Removed27 Oct