游客

标题:ZenCart SQL批量常用数据库命令
正文:
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_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 featured; # 清空促销商品TRUNCATE TABLE salemaker_sales; # 清空特价商品TRUNCATE TABLE special
[<<][[1]][2][3][>>]

查看评论(0)
发表评论



首页