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;
转载请注明出处!小鱼阁工作室 -专注zencart建站,织梦企业建站,ecshop商城,二次开发,产品采集,模板修改!技术QQ 631992791
原文地址:https://www.cnblogs.com/afish/p/3922623.html