|
到OpenCart的数据库管理工具phpmyadmin -> 中SQL中执行
1 TRUNCATE TABLE `attribute`;
2 TRUNCATE TABLE `attribute_description`;
3 TRUNCATE TABLE `attribute_group`;
4 TRUNCATE TABLE `attribute_group_description`;
5 TRUNCATE TABLE `category`;
6 TRUNCATE TABLE `category_description`;
7 TRUNCATE TABLE `category_to_layout`;
8 TRUNCATE TABLE `category_to_store`;
9 TRUNCATE TABLE `option`;
10 TRUNCATE TABLE `option_description`;
11 TRUNCATE TABLE `option_value`;
12 TRUNCATE TABLE `option_value_description`;
13 TRUNCATE TABLE `product`;
14 TRUNCATE TABLE `product_attribute`;
15 TRUNCATE TABLE `product_description`;
16 TRUNCATE TABLE `product_discount`;
17 TRUNCATE TABLE `product_image`;
18 TRUNCATE TABLE `product_option`;
19 TRUNCATE TABLE `product_option_value`;
20 TRUNCATE TABLE `product_reward`;
21 TRUNCATE TABLE `product_special`;
22 TRUNCATE TABLE `product_tag`;
23 TRUNCATE TABLE `product_to_category`;
24 TRUNCATE TABLE `product_to_download`;
25 TRUNCATE TABLE `product_to_layout`;
26 TRUNCATE TABLE `product_to_store`;
|