最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

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

programmeradmin2浏览0评论

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?

发布评论

评论列表(0)

  1. 暂无评论