对于mysql互换表中2列数据方法的讲解

+----+--------+----------------+--------+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; +----+--------+----------------+--------+(北联网教程,专业提供视频软件下载)

……