西部数码主机 | 阿里云主机| 虚拟主机 | 服务器 | 返回乐道官网
当前位置: 主页 > php教程 > zencart教程 >

zencart如何清空商品演示数据和没有商品数据的

时间:2011-08-16 15:21来源:未知 作者:好模板 点击:
清空商品商品、属性、分类 TRUNCATE TABLE categories; TRUNCATE TABLE categories_description; # 清空商品和属性 TRUNCATE TABLE media_clips; TRUNCATE TABLE media_manager; TRUNCATE TABLE media_to_products; TRUNCATE TABLE media_

 清空商品商品、属性、分类

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;

(责任编辑:好模板)
顶一下
(2)
100%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容