List:General Discussion« Previous MessageNext Message »
From:Dehua Yang Date:October 17 2012 4:24pm
Subject:Re: Possible to copy the key field to another on INSERT?
View as plain text  
Hello  Shawn

Thanks for your tips. We send the " select   LAST_INSERT_ID() " by our data
middle ware.

I'll ask the middle ware team to check it out.



On Wed, Oct 17, 2012 at 9:33 PM, Shawn Green <shawn.l.green@stripped>wrote:

> Hello Dehua,
>
>
> On 10/17/2012 3:33 AM, Dehua Yang wrote:
>
>> select   LAST_INSERT_ID() ; Under high concurrency  , it would return
>> other
>> threads value to you.
>>
>>
> Incorrect. The results of LAST_INSERT_ID() are connection-specific. The
> activity on other connections will not change or alter the value for the
> current connection.  Only actions taken by the current connection can
> change this value.
>
> http://dev.mysql.com/doc/**refman/5.5/en/information-**
>
> functions.html#function_last-**insert-id<http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id>
>
>
> --
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
> Office: Blountville, TN
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
B.rgds / Whitepoplar (杨德华)

Thread
Possible to copy the key field to another on INSERT?W. D.17 Oct
Re: Possible to copy the key field to another on INSERT?Dehua Yang17 Oct
  • Re: Possible to copy the key field to another on INSERT?Shawn Green17 Oct
    • Re: Possible to copy the key field to another on INSERT?Dehua Yang17 Oct
Re: Possible to copy the key field to another on INSERT?Claudio Nanni17 Oct
  • Re: Possible to copy the key field to another on INSERT?W. D.17 Oct
  • Re: Possible to copy the key field to another on INSERT?W. D.18 Oct