Can `select` in reads a partially updated row in MySQL with the Read Uncommited isolation level? - Stack Overflow

admin2025-04-18  4

Suppose the following two statements are executed in parallel:

-- before: col1=val1, col2=val2
UPDATE my_table SET col1=new_val1,col2=new_val2 WHERE col3=val3
SELECT col1,col2 FROM my_table WHERE col3=val3

Is it possible that the select query returns col1=new_val1,col2=val2, i.e., partially updated row?

转载请注明原文地址:http://anycun.com/QandA/1744938326a89750.html