UPDATE table_name
SET column1 = (SELECT @temp := column1),
column1 = column2,
column2 = @temp;
01-04
1182
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-27
4264
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-19
UPDATE table_name
SET column1 = (SELECT @temp := column1),
column1 = column2,
column2 = @temp;