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