mysql一张表两个字段互换
update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;
转载于:https://blog.51cto.com/xuqin/2125465
mysql一张表两个字段互换
update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;
转载于:https://blog.51cto.com/xuqin/2125465