清空测试数据
mysql> use dexin
Database changed
mysql> show tables;
+-------------------------+
| Tables_in_dexin |
+-------------------------+
| dbver |
| tf_action |
| tf_admin_user |
| tf_category |
| tf_collection |
| tf_configs |
| tf_country_area |
| tf_coupon |
| tf_date_email |
| tf_express |
| tf_face |
| tf_home_banner |
| tf_home_module |
| tf_home_rec |
| tf_like_survey |
| tf_order |
| tf_order_address |
| tf_order_express |
| tf_order_product |
| tf_order_refund |
| tf_order_refund_cert |
| tf_order_return_express |
| tf_platform_msg |
| tf_process_step |
| tf_product |
| tf_product_attr_key |
| tf_product_attr_symbol |
| tf_product_attr_val |
| tf_product_img |
| tf_product_sku |
| tf_purpose |
| tf_rofeia_world |
| tf_shopping_car |
| tf_single_article |
| tf_style |
| tf_user |
| tf_user_address |
| tf_user_coupon |
+-------------------------+
38 rows in set (0.00 sec)
mysql> truncate table tf_order;
Query OK, 0 rows affected (0.02 sec)
mysql> truncate table tf_order_address;
Query OK, 0 rows affected (0.03 sec)
mysql> truncate table tf_order_express;
Query OK, 0 rows affected (0.01 sec)
mysql> truncate table tf_order_product;
Query OK, 0 rows affected (0.02 sec)
mysql> truncate table tf_order_refund;
Query OK, 0 rows affected (0.02 sec)
mysql> truncate table tf_order_refund_cert;
Query OK, 0 rows affected (0.02 sec)
局部清理就可以了,做好备份!