mysql语句修改zencart产品原价为特价的倍数

mysql语句修改zencart产品原价为特价的倍数,下面语句将原价设为特价的3倍:

update products as p inner join specials as s on s.products_id=p.products_id set p.products_price=s.specials_new_products_price*3;
update products as p inner join specials as s on s.products_id=p.products_id set p.products_price_sorter=s.specials_new_products_price*3;

 

mysql语句修改zencart产品原价为特价的倍数,布布扣,bubuko.com

mysql语句修改zencart产品原价为特价的倍数

上一篇:mysql自增字段AUTO_INCREMENT重排或归零


下一篇:ABAP 使用SET PF-STATUS时报错PERFORM_TOO_MANY_PARAMETERS