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 (杨德华）
