> What is "the correct result"? The correct result is the data in the updated column after commit.
For example, if I have: Table1 ===== - id - name INSERT INTO Table1 (id, name) VALUES (1, 'AAA') UPDATE LOW PRIORITY Table1 SET name = 'BBB' SELECT name FROM Table1 Will it return BBB? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]