mysql一张表两个字段互换

update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;

mysql一张表两个字段互换

地址:https://blog.csdn.net/fdipzone/article/details/50864196