I want to do this: [1] read a row from table table_1 with select [2] change a row from [1] with update [3] change another row in table table_1 with update
But queries [2] and [3] in the time of invoking, assume that row from query [1] wasn't changed. Should I use LOCK TABLES? - I've tried that in query browser, but that doesn't prevent another thread to modify locked table. -- View this message in context: http://www.nabble.com/How-to-guarantee-an-integrity-in-this-case--tp17988300p17988300.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
