业务形式:本司专业提供深圳外贸网站建设,外贸网站建设,深圳网站建设,ZenCart模板
环球商务国际 版权所有 ©2005-2014 35EBS.All rights reserved.
粤ICP备05007577号
Processed in 0.020259 second(s) , 38 queries
清空商品商品、属性、分类
TRUNCATE TABLE categories;
TRUNCATE TABLE categories_description;
# 清空商品和属性
TRUNCATE TABLE media_clips;
TRUNCATE TABLE media_manager;
TRUNCATE TABLE media_to_products;
TRUNCATE TABLE media_types;
TRUNCATE TABLE music_genre;
TRUNCATE TABLE product_music_extra;
TRUNCATE TABLE product_types_to_category;
TRUNCATE TABLE products;
TRUNCATE TABLE products_attributes;
TRUNCATE TABLE products_attributes_download;
TRUNCATE TABLE products_description;
TRUNCATE TABLE products_discount_quantity;
TRUNCATE TABLE products_notifications;
TRUNCATE TABLE products_options;
TRUNCATE TABLE products_options_types;
TRUNCATE TABLE products_options_values;
TRUNCATE TABLE products_options_values_to_products_options;
TRUNCATE TABLE products_to_categories;
TRUNCATE TABLE record_artists;
TRUNCATE TABLE record_artists_info;
TRUNCATE TABLE record_company;
TRUNCATE TABLE record_company_info;
# 清空客户评论
TRUNCATE TABLE reviews;
TRUNCATE TABLE reviews_description;
# 清空推荐商品
TRUNCATE TABLE featured;
# 清空厂家及资料
TRUNCATE TABLE manufacturers;
TRUNCATE TABLE manufacturers_info;
# 清空团体价格
TRUNCATE TABLE group_pricing;
# 清空促销商品
TRUNCATE TABLE salemaker_sales;
# 清空特价商品
TRUNCATE TABLE specials;
删除指定类目下的所有商品,但是不删除该类目
delete from ‘products’ WHERE master_categories_id=21 21是要删除的哪个类ID,后台可以看到。