List:General Discussion« Previous MessageNext Message »
From:Chris Date:October 23 2006 9:03am
Subject:Re: Does 'insert' return a value?
View as plain text  
黄小聪 wrote:
> When I insert a record into a table
> Does the insert return a value that where the record have been inserted
> into?

No.

You need to "select last_insert_id()" or use a function in your 
programming language (eg php has php.net/mysql_insert_id).
Thread
Does 'insert' return a value?黄小聪23 Oct
  • Re: Does 'insert' return a value?Chris23 Oct
  • Re: Does 'insert' return a value?Martijn Tonies23 Oct
  • Re: Does 'insert' return a value?Martijn Tonies24 Oct
    • Re: Does 'insert' return a value?Chris24 Oct