mysql 调换两列数据_mysql 实现互换表中两列数据方法简单实例 参考:https://blog.csdn.net/weixin_34732602/article/details/113598013 update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;