- update ecs_goods SET goods_number= '5000' 设置所有演示数据库存数为5000
- update ecs_ad set end_time='1625846400' 设置广告结束时间
- UPDATE ecs_goods SET promote_end_date = '1625846400' where promote_end_date <>0 设置促销商品的促销结束时间
- UPDATE ecs_goods SET goods_number= '2000' 设置产品库存数量删除ECSHOP所有商品的精品属性:update ecs_goods set is_best = '0'
- 删除所有产品的新品属性:update ecs_goods set is_new = '0'
- 删除所有产品的热销属性:update ecs_goods set is_hot = '0'
- 依次类推,删除所有促销商品就是:update ecs_goods set is_promote = '0'
- 删除表 delete from ecs_xxx;(xxx=要删除的表)
|