[摘要]+----+--------+----------------+--------+5 rows in set (0.00 sec)
mysql> update product as a, pr...
+----+--------+----------------+--------+5 rows in set (0.00 sec)
mysql> update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;
Query OK, 5 rows affected (0.01 sec)
Rows matched: 5 Changed: 5 Warnings: 0mysql> select * from product;
+----+--------+----------------+--------+ |
关键词： 对于mysql互换表中2列数据办法的讲解