mysql update 结果

UPDATE t1 SET col1 = col1 + 1, col2 = col1;

col2 = ?

The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. The result is that col1 and col2 have the same value. This behavior differs from standard SQL.

标签: mysql
相关文章
评论留言
发布留言