Re: is table or row write locked during an update ?

2002-09-11 Thread Joseph Bueno
BRACHET,STEPHAN (Non-HP-France,ex1) wrote: > Hello, > > I need to do an update on a table : > > * Something like this : * > UPDATE my_table mt > SET mt.field1 = mt.field1 + 1 > WHERE mt.id = 100 > * > > And there can have concurrent updates on this record

is table or row write locked during an update ?

2002-09-11 Thread BRACHET,STEPHAN (Non-HP-France,ex1)
Hello, I need to do an update on a table : * Something like this : * 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 an