mysql中如何解决把A列数据输入到了B列,把B列数据输入到了A列。
select * from product;
update
product
as
a, product
as
b
set
a.original_price=b.price, a.price=b.original_price
where
a.id=b.id;
mysql中如何解决把A列数据输入到了B列,把B列数据输入到了A列。
select * from product;
update
product
as
a, product
as
b
set
a.original_price=b.price, a.price=b.original_price
where
a.id=b.id;