zencart如何清空商品演示数据和没有商品数据的sql执行语句
#清空商品商品、属性、分类
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;
 
                    
                     
                    
                 
                    
                
 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号