1 message in com.mysql.lists.mysqlis table or row write locked during u...
FromSent OnAttachments
BRACHET,STEPHAN (Non-HP-France,ex1)09 Sep 2002 06:46 
Subject:is table or row write locked during update ?
From:BRACHET,STEPHAN (Non-HP-France,ex1) (step@non.hp.com)
Date:09/09/2002 06:46:55 AM
List:com.mysql.lists.mysql

Hello,

I need to do an update on a table :

UPDATE my_table mt SET mt.field1 = mt.field1 + 1 WHERE mt.id = 100

And there can have concurrent updates on this record. is there a risk of 2 (or more) updates done at the same time and my field and the result of the query to damage the field or does all the updates done in a queue ... ?

Thank you for your help

Stephan