删数据sql

truncate table onl_cgform_button;
truncate table onl_cgform_enhance_java;
truncate table onl_cgform_enhance_js;
truncate table onl_cgform_enhance_sql;
truncate table onl_cgform_field;
truncate table onl_cgform_head;
truncate table onl_cgform_index;
truncate table pdman_db_version;
truncate table shop_category_lei_bak;
truncate table shop_product_category_lei_bak;
truncate table shop_product_lei_bak;
truncate table t_address;
truncate table t_after_sale_template;
truncate table t_association_word;
truncate table t_bank_account;
truncate table t_carton;
truncate table t_carton_copy1;
truncate table t_carton_detail;
truncate table t_category_nav_lei_bak;
truncate table t_city;
truncate table t_collection;
truncate table t_collection_detail;
truncate table t_config_version;
truncate table t_contacts_info;
truncate table t_coupon;
truncate table t_coupon_package;
truncate table t_customer;
truncate table t_deal_campaign;
truncate table t_deal_campaign_share_coupon;
truncate table t_deal_campaign_share_coupon_detail;
truncate table t_deals_info;
truncate table t_discount_code;
truncate table t_district;
truncate table t_exchange_rate;
truncate table t_express_hundred;
truncate table t_free_ship;
truncate table t_front_category——1;
truncate table t_import_multipart_file;
truncate table t_import_sku_error_record;
truncate table t_import_stock_error_record;
truncate table t_invoice;
truncate table t_kv;
truncate table t_mail;
truncate table t_marketing_label;
truncate table t_message_notification;
truncate table t_modif_b_mobil_log;
truncate table t_online_log;
truncate table t_order;
truncate table t_order_address;
truncate table t_order_aftersale;
truncate table t_order_aftersale_config;
truncate table t_order_aftersale_detail;
truncate table t_order_aftersale_img;
truncate table t_order_aftersale_reason;
truncate table t_order_b;
truncate table t_order_copy1;
truncate table t_order_copy2;
truncate table t_order_copy3;
truncate table t_order_coupon;
truncate table t_order_detail;
truncate table t_order_group;
truncate table t_order_refund;
truncate table t_order_statistics;
truncate table t_order_time_config;
truncate table t_package;
truncate table t_package_item;
truncate table t_pay;
truncate table t_price_rule;
truncate table t_product_20220711;
truncate table t_product_bk;
truncate table t_product_collection_detail;
truncate table t_product_collection_log;
truncate table t_product_collection_template;
truncate table t_product_copy1;
truncate table t_product_copy2;
truncate table t_product_copy3;
truncate table t_product_forecast_sales;
truncate table t_product_log;
truncate table t_product_online_log;
truncate table t_product_restock_request;
truncate table t_promotion;
truncate table t_promotion_flash;
truncate table t_promotion_flash_sku;
truncate table t_promotion_group;
truncate table t_promotion_group_sku;
truncate table t_province;
truncate table t_purchase;
truncate table t_purchase_info;
truncate table t_purchase_order;
truncate table t_purchase_order_detail;
truncate table t_purchase_order_detail_copy1;
truncate table t_purchase_order_detail_copy2;
truncate table t_purchase_print_sku;
truncate table t_purchase_pro;
truncate table t_purchase_pro_record;
truncate table t_purchase_relevance_third_order_code;
truncate table t_purchase_send;
truncate table t_purchase_split_detail;
truncate table t_receive_detail_purchase_sku_identity;
truncate table t_receive_order;
truncate table t_receive_order_copy1;
truncate table t_receive_order_detail;
truncate table t_receive_order_detail_copy1;
truncate table t_receive_order_split_detail;
truncate table t_receive_us_package;
truncate table t_recommend_product;
truncate table t_record_order_auto_pay_fail;
truncate table t_record_stock_out;
truncate table t_refund;
truncate table t_relation_purchase_order;
truncate table t_relation_purchase_order_copy1;
truncate table t_relation_purchase_third_part;
truncate table t_relation_receive_detail_purchase;
truncate table t_relation_receive_detail_purchase_copy1;
truncate table t_relation_receive_order_sku;
truncate table t_relation_store_order;
truncate table t_remark;
truncate table t_search_history;
truncate table t_search_hot_word;
truncate table t_search_tip_word;
truncate table t_seller_permit    ;
truncate table t_share_campaign;
truncate table t_share_campaign_coupon;
truncate table t_share_campaign_coupon_detail;
truncate table t_shipping_detail;
truncate table t_shipping_template;
truncate table t_shop;
truncate table t_shop_account;
truncate table t_shop_bank;
truncate table t_shop_product_statics;
truncate table t_shop_statics;
truncate table t_shop_tag_computation;
truncate table t_shop_withdrew;
truncate table t_shop_withdrew_month_count;
truncate table t_shop_withdrew_tax_config;
truncate table t_shop_withdrew_tax_open;
truncate table t_shopify_custom_app_credential;
truncate table t_sku_attribute_log;
truncate table t_sku_copy1;
truncate table t_sku_copy2;
truncate table t_sku_copy3;
truncate table t_sku_copy4;
truncate table t_sku_copy5;
truncate table t_sku_restock_request;
truncate table t_sku_stock;
truncate table t_sku_warehouse_stock_copy1;
truncate table t_sku_warehouse_stock_copy2;
truncate table t_spu_20220711;
truncate table t_spu_audit_log;
truncate table t_spu_copy1;
truncate table t_spu_copy2;
truncate table t_spu_copy3;
truncate table t_stock_operate_log;
truncate table t_store;
truncate table t_store_fulfillment;
truncate table t_store_order;
truncate table t_store_order_detail;
truncate table t_store_order_failure_record;
truncate table t_store_order_statics;
truncate table t_store_product;
truncate table t_store_product_export_record;
truncate table t_street;
truncate table t_supplier_account_statement;
truncate table t_supplier_cl_pro;
truncate table t_supplier_cl_pro_record;
truncate table t_supplier_classification;
truncate table t_supplier_contract;
truncate table t_supplier_info;
truncate table t_supplier_invoice;
truncate table t_supplier_statement_detail;
truncate table t_supplier_statement_header;
truncate table t_supplier_user;
truncate table t_sync_order_record;
truncate table t_sync_user_record;
truncate table t_tag_config;
truncate table t_task_notify;
truncate table t_task_notify_date;
truncate table t_task_notify_record;
truncate table t_third_category;
truncate table t_third_part_request_info;
truncate table t_third_product_record;
truncate table t_third_sku_stock;
truncate table t_unit;
truncate table t_user;
truncate table t_user_cart;
truncate table t_user_coupon;
truncate table t_user_discount_code;
truncate table t_user_discount_code1;
truncate table t_user_login;
truncate table t_user_shop;
truncate table t_white_list;
truncate table t_wms_abnormal_operation_log;
truncate table t_wms_asn_detail;
truncate table t_wms_asn_header;
truncate table t_wms_car_driver;
truncate table t_wms_car_out;
truncate table t_wms_code_holder_point;
truncate table t_wms_container;
truncate table t_wms_delivery_order_box;
truncate table t_wms_delivery_order_detail;
truncate table t_wms_delivery_order_header;
truncate table t_wms_device;
truncate table t_wms_doc_putaway;
truncate table t_wms_imperfections;
truncate table t_wms_location;
truncate table t_wms_location_copy1;
truncate table t_wms_location_copy2;
truncate table t_wms_log;
truncate table t_wms_multiple_items;
truncate table t_wms_multiple_items_copy1;
truncate table t_wms_multiple_items_copy2;
truncate table t_wms_order_relation;
truncate table t_wms_partition;
truncate table t_wms_pick_header;
truncate table t_wms_pick_task;
truncate table t_wms_received_exception_reason;
truncate table t_wms_record_complete_receive_log;
truncate table t_wms_record_stock_out_log;
truncate table t_wms_return_supplier_detail;
truncate table t_wms_return_supplier_header;
truncate table t_wms_return_warehouse_detail;
truncate table t_wms_return_warehouse_header;
truncate table t_wms_shipping_detail;
truncate table t_wms_shipping_header;
truncate table t_wms_sku_ext;
truncate table t_wms_stock_batch_att;
truncate table t_wms_stock_batch_loc;
truncate table t_wms_stock_pick;
truncate table t_wms_stock_sync;
truncate table t_wms_stock_task;
truncate table t_wms_transport_car;
truncate table t_wms_unique_code;
truncate table t_wms_warehouse_copy1;
truncate table t_wms_warehouse_depart;
truncate table t_wms_warehouse_location_copy1;
truncate table t_wms_warehouse_location_order;
truncate table t_wms_warehouse_shop;
truncate table t_wms_wave;
truncate table test;
truncate table tmp1;
truncate table wms_abnormal;

delete from onl_cgform_button;
delete from onl_cgform_enhance_java;
delete from onl_cgform_enhance_js;
delete from onl_cgform_enhance_sql;
delete from onl_cgform_field;
delete from onl_cgform_head;
delete from onl_cgform_index;
delete from pdman_db_version;
delete from shop_category;
delete from shop_category_lei_bak;
delete from shop_config;
delete from shop_product;
delete from shop_product_category;
delete from shop_product_category_lei_bak;
delete from shop_product_lei_bak;
delete from t_address;
delete from t_after_sale_template;
delete from t_association_word;
delete from t_bank_account;
delete from t_carton;
delete from t_carton_copy1;
delete from t_carton_detail;
delete from t_category_nav_lei_bak;
delete from t_city;
delete from t_collection;
delete from t_collection_detail;
delete from t_config_version;
delete from t_contacts_info;
delete from t_coupon;
delete from t_coupon_package;
delete from t_customer;
delete from t_deal_campaign;
delete from t_deal_campaign_share_coupon;
delete from t_deal_campaign_share_coupon_detail;
delete from t_deals_info;
delete from t_discount_code;
delete from t_district;
delete from t_exchange_rate;
delete from t_express_hundred;
delete from t_free_ship;
delete from t_front_category——1;
delete from t_import_multipart_file;
delete from t_import_sku_error_record;
delete from t_import_stock_error_record;
delete from t_invoice;
delete from t_kv;
delete from t_mail;
delete from t_marketing_label;
delete from t_message_notification;
delete from t_modif_b_mobil_log;
delete from t_notify;
delete from t_notify_pg_event;
delete from t_online_log;
delete from t_operate_advert;
delete from t_operate_banner;
delete from t_operate_cms_page;
delete from t_operate_cms_page_component;
delete from t_operate_cms_page_component_info;
delete from t_operate_icon;
delete from t_operate_share;
delete from t_operate_tiling;
delete from t_order;
delete from t_order_address;
delete from t_order_aftersale;
delete from t_order_aftersale_config;
delete from t_order_aftersale_detail;
delete from t_order_aftersale_img;
delete from t_order_aftersale_reason;
delete from t_order_b;
delete from t_order_copy1;
delete from t_order_copy2;
delete from t_order_copy3;
delete from t_order_coupon;
delete from t_order_detail;
delete from t_order_group;
delete from t_order_refund;
delete from t_order_statistics;
delete from t_order_time_config;
delete from t_package;
delete from t_package_item;
delete from t_pay;
delete from t_price_rule;
delete from t_product_20220711;
delete from t_product_attribute;
delete from t_product_attribute_value;
delete from t_product_bk;
delete from t_product_collection_detail;
delete from t_product_collection_log;
delete from t_product_collection_template;
delete from t_product_copy1;
delete from t_product_copy2;
delete from t_product_copy3;
delete from t_product_forecast_sales;
delete from t_product_log;
delete from t_product_online_log;
delete from t_product_restock_request;
delete from t_promotion;
delete from t_promotion_flash;
delete from t_promotion_flash_sku;
delete from t_promotion_group;
delete from t_promotion_group_sku;
delete from t_province;
delete from t_purchase;
delete from t_purchase_info;
delete from t_purchase_order;
delete from t_purchase_order_detail;
delete from t_purchase_order_detail_copy1;
delete from t_purchase_order_detail_copy2;
delete from t_purchase_print_sku;
delete from t_purchase_pro;
delete from t_purchase_pro_record;
delete from t_purchase_relevance_third_order_code;
delete from t_purchase_send;
delete from t_purchase_split_detail;
delete from t_questionnaire;
delete from t_questionnaire_select;
delete from t_questionnaire_user_select;
delete from t_receive_detail_purchase_sku_identity;
delete from t_receive_order;
delete from t_receive_order_copy1;
delete from t_receive_order_detail;
delete from t_receive_order_detail_copy1;
delete from t_receive_order_split_detail;
delete from t_receive_us_package;
delete from t_recommend_product;
delete from t_record_order_auto_pay_fail;
delete from t_record_stock_out;
delete from t_refund;
delete from t_relation_purchase_order;
delete from t_relation_purchase_order_copy1;
delete from t_relation_purchase_third_part;
delete from t_relation_receive_detail_purchase;
delete from t_relation_receive_detail_purchase_copy1;
delete from t_relation_receive_order_sku;
delete from t_relation_store_order;
delete from t_remark;
delete from t_search_history;
delete from t_search_hot_word;
delete from t_search_tip_word;
delete from t_seller_permit    ;
delete from t_share_campaign;
delete from t_share_campaign_coupon;
delete from t_share_campaign_coupon_detail;
delete from t_shipping_detail;
delete from t_shipping_template;
delete from t_shop;
delete from t_shop_account;
delete from t_shop_bank;
delete from t_shop_product_statics;
delete from t_shop_statics;
delete from t_shop_tag_computation;
delete from t_shop_withdrew;
delete from t_shop_withdrew_month_count;
delete from t_shop_withdrew_tax_config;
delete from t_shop_withdrew_tax_open;
delete from t_shopify_custom_app_credential;
delete from t_sku_attribute_log;
delete from t_sku_copy1;
delete from t_sku_copy2;
delete from t_sku_copy3;
delete from t_sku_copy4;
delete from t_sku_copy5;
delete from t_sku_restock_request;
delete from t_sku_stock;
delete from t_sku_warehouse_stock_copy1;
delete from t_sku_warehouse_stock_copy2;
delete from t_spu_20220711;
delete from t_spu_audit_log;
delete from t_spu_copy1;
delete from t_spu_copy2;
delete from t_spu_copy3;
delete from t_stock_operate_log;
delete from t_store;
delete from t_store_fulfillment;
delete from t_store_order;
delete from t_store_order_detail;
delete from t_store_order_failure_record;
delete from t_store_order_statics;
delete from t_store_product;
delete from t_store_product_export_record;
delete from t_street;
delete from t_supplier_account_statement;
delete from t_supplier_cl_pro;
delete from t_supplier_cl_pro_record;
delete from t_supplier_classification;
delete from t_supplier_contract;
delete from t_supplier_detail;
delete from t_supplier_info;
delete from t_supplier_invoice;
delete from t_supplier_log;
delete from t_supplier_statement_detail;
delete from t_supplier_statement_header;
delete from t_supplier_store;
delete from t_supplier_user;
delete from t_sync_order_record;
delete from t_sync_user_record;
delete from t_sys_announcement;
delete from t_sys_announcement_send;
delete from t_sys_category;
delete from t_sys_data_log;
delete from t_sys_depart;
delete from t_sys_depart_role;
delete from t_sys_dict;
delete from t_sys_dict_item;
delete from t_sys_fill_rule;
delete from t_sys_log;
delete from t_sys_permission;
delete from t_sys_permission_data_rule;
delete from t_sys_position;
delete from t_sys_role;
delete from t_sys_role_permission;
delete from t_sys_sms;
delete from t_sys_sms_template;
delete from t_sys_user;
delete from t_sys_user_agent;
delete from t_sys_user_depart;
delete from t_sys_user_role;
delete from t_tag_config;
delete from t_task_notify;
delete from t_task_notify_date;
delete from t_task_notify_record;
delete from t_third_category;
delete from t_third_part_request_info;
delete from t_third_product_record;
delete from t_third_sku_stock;
delete from t_unit;
delete from t_user;
delete from t_user_cart;
delete from t_user_coupon;
delete from t_user_discount_code;
delete from t_user_discount_code1;
delete from t_user_login;
delete from t_user_shop;
delete from t_white_list;
delete from t_wms_abnormal_operation_log;
delete from t_wms_asn_detail;
delete from t_wms_asn_header;
delete from t_wms_car_driver;
delete from t_wms_car_out;
delete from t_wms_code_holder_point;
delete from t_wms_container;
delete from t_wms_delivery_order_box;
delete from t_wms_delivery_order_detail;
delete from t_wms_delivery_order_header;
delete from t_wms_device;
delete from t_wms_doc_putaway;
delete from t_wms_imperfections;
delete from t_wms_location;
delete from t_wms_location_copy1;
delete from t_wms_location_copy2;
delete from t_wms_log;
delete from t_wms_multiple_items;
delete from t_wms_multiple_items_copy1;
delete from t_wms_multiple_items_copy2;
delete from t_wms_order_relation;
delete from t_wms_partition;
delete from t_wms_pick_header;
delete from t_wms_pick_task;
delete from t_wms_received_exception_reason;
delete from t_wms_record_complete_receive_log;
delete from t_wms_record_stock_out_log;
delete from t_wms_return_supplier_detail;
delete from t_wms_return_supplier_header;
delete from t_wms_return_warehouse_detail;
delete from t_wms_return_warehouse_header;
delete from t_wms_shipping_detail;
delete from t_wms_shipping_header;
delete from t_wms_sku_ext;
delete from t_wms_stock_batch_att;
delete from t_wms_stock_batch_loc;
delete from t_wms_stock_pick;
delete from t_wms_stock_sync;
delete from t_wms_stock_task;
delete from t_wms_transport_car;
delete from t_wms_unique_code;
delete from t_wms_warehouse;
delete from t_wms_warehouse_copy1;
delete from t_wms_warehouse_depart;
delete from t_wms_warehouse_location_copy1;
delete from t_wms_warehouse_location_order;
delete from t_wms_warehouse_shop;
delete from t_wms_wave;
delete from test;
delete from tmp1;
delete from wms_abnormal;