首页 » Linux » OpenCart » 阅读文章
OpenCart清空演示数据的sql语句
到phpmyadmin -> SQL中执行
TRUNCATE TABLE `attribute`; TRUNCATE TABLE `attribute_description`; TRUNCATE TABLE `attribute_group`; TRUNCATE TABLE `attribute_group_description`; TRUNCATE TABLE `category`; TRUNCATE TABLE `category_description`; TRUNCATE TABLE `category_to_layout`; TRUNCATE TABLE `category_to_store`; TRUNCATE TABLE `option`; TRUNCATE TABLE `option_description`; TRUNCATE TABLE `option_value`; TRUNCATE TABLE `option_value_description`; TRUNCATE TABLE `product`; TRUNCATE TABLE `product_attribute`; TRUNCATE TABLE `product_description`; TRUNCATE TABLE `product_discount`; TRUNCATE TABLE `product_image`; TRUNCATE TABLE `product_option`; TRUNCATE TABLE `product_option_value`; TRUNCATE TABLE `product_reward`; TRUNCATE TABLE `product_special`; TRUNCATE TABLE `product_tag`; TRUNCATE TABLE `product_to_category`; TRUNCATE TABLE `product_to_download`; TRUNCATE TABLE `product_to_layout`; TRUNCATE TABLE `product_to_store`;
下载地址:Clear-opencart.sql
opencart V1.513英文版测试通过。
声明: 本文由Ezencart原创,转载请保留链接:OpenCart清空演示数据的sql语句
评论 共0条 (RSS 2.0) 发表评论