清空测试数据

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)


局部清理就可以了,做好备份!

原文地址:https://www.cnblogs.com/jiqing9006/p/9673253.html