您当前的位置:首页 > CMS常见问题 > ecshop常见问题 >

ecshop常用清空数据库表SQL语句

来源:仿站公司0
TRUNCATE TABLE `ecs_account_log`;
TRUNCATE TABLE `ecs_ad`;
TRUNCATE TABLE `ecs_admin_action`;
TRUNCATE TABLE `ecs_admin_log`;
TRUNCATE TABLE `ecs_admin_message`;
TRUNCATE TABLE `ecs_adsense`;
TRUNCATE TABLE `ecs_ad_custom`;
TRUNCATE TABLE `ecs_ad_position`;
TRUNCATE TABLE `ecs_affiliate_log`;
TRUNCATE TABLE `ecs_agency`;
TRUNCATE TABLE `ecs_area_region`;
TRUNCATE TABLE `ecs_article`;
TRUNCATE TABLE `ecs_article_cat`;
TRUNCATE TABLE `ecs_attribute`;
TRUNCATE TABLE `ecs_attribute_color`;
TRUNCATE TABLE `ecs_auction_log`;
TRUNCATE TABLE `ecs_auto_manage`;
TRUNCATE TABLE `ecs_back_goods`;
TRUNCATE TABLE `ecs_back_order`;
TRUNCATE TABLE `ecs_bonus_type`;
TRUNCATE TABLE `ecs_booking_goods`;
TRUNCATE TABLE `ecs_brand`;
TRUNCATE TABLE `ecs_card`;
TRUNCATE TABLE `ecs_cart`;
TRUNCATE TABLE `ecs_cart_combo`;
TRUNCATE TABLE `ecs_case`;
TRUNCATE TABLE `ecs_case_cat`;
TRUNCATE TABLE `ecs_category`;
TRUNCATE TABLE `ecs_cat_recommend`;
TRUNCATE TABLE `ecs_chushoushangbiao`;
TRUNCATE TABLE `ecs_chushouwangdian`;
TRUNCATE TABLE `ecs_collect_goods`;
TRUNCATE TABLE `ecs_comment`;
TRUNCATE TABLE `ecs_delivery_goods`;
TRUNCATE TABLE `ecs_delivery_order`;
TRUNCATE TABLE `ecs_email_list`;
TRUNCATE TABLE `ecs_email_sendlist`;
TRUNCATE TABLE `ecs_error_log`;
TRUNCATE TABLE `ecs_exchange_goods`;
TRUNCATE TABLE `ecs_favourable_activity`;
TRUNCATE TABLE `ecs_feedback`;
TRUNCATE TABLE `ecs_friend_link`;
TRUNCATE TABLE `ecs_goods`;
TRUNCATE TABLE `ecs_goods_activity`;
TRUNCATE TABLE `ecs_goods_article`;
TRUNCATE TABLE `ecs_goods_attr`;
TRUNCATE TABLE `ecs_goods_cat`;
TRUNCATE TABLE `ecs_goods_gallery`;
TRUNCATE TABLE `ecs_goods_service`;
TRUNCATE TABLE `ecs_goods_type`;
TRUNCATE TABLE `ecs_group_goods`;
TRUNCATE TABLE `ecs_gujia_douyin`;
TRUNCATE TABLE `ecs_gujia_kuaishou`;
TRUNCATE TABLE `ecs_gujia_toutiao`;
TRUNCATE TABLE `ecs_gujia_weibo`;
TRUNCATE TABLE `ecs_gujia_weixin`;
TRUNCATE TABLE `ecs_ip_log`;
TRUNCATE TABLE `ecs_keywords`;
TRUNCATE TABLE `ecs_linkage`;
TRUNCATE TABLE `ecs_link_goods`;
TRUNCATE TABLE `ecs_member_price`;
TRUNCATE TABLE `ecs_nav`;
TRUNCATE TABLE `ecs_order`;
TRUNCATE TABLE `ecs_orderdata`;
TRUNCATE TABLE `ecs_order_action`;
TRUNCATE TABLE `ecs_order_goods`;
TRUNCATE TABLE `ecs_order_info`;
TRUNCATE TABLE `ecs_order_pay`;
TRUNCATE TABLE `ecs_pack`;
TRUNCATE TABLE `ecs_package_goods`;
TRUNCATE TABLE `ecs_pay_log`;
TRUNCATE TABLE `ecs_plugins`;
TRUNCATE TABLE `ecs_products`;
TRUNCATE TABLE `ecs_reg_extend_info`;
TRUNCATE TABLE `ecs_reg_fields`;
TRUNCATE TABLE `ecs_role`;
TRUNCATE TABLE `ecs_searchengine`;
TRUNCATE TABLE `ecs_service`;
TRUNCATE TABLE `ecs_service_cat`;
TRUNCATE TABLE `ecs_sessions`;
TRUNCATE TABLE `ecs_sessions_data`;
TRUNCATE TABLE `ecs_shangbiao`;
TRUNCATE TABLE `ecs_shangbiaoqiugou`;
TRUNCATE TABLE `ecs_snatch_log`;
TRUNCATE TABLE `ecs_stats`;
TRUNCATE TABLE `ecs_suppliers`;
TRUNCATE TABLE `ecs_tag`;
TRUNCATE TABLE `ecs_template`;
TRUNCATE TABLE `ecs_times`;
TRUNCATE TABLE `ecs_topic`;
TRUNCATE TABLE `ecs_users`;
TRUNCATE TABLE `ecs_user_account`;
TRUNCATE TABLE `ecs_user_address`;
TRUNCATE TABLE `ecs_user_bank`;
TRUNCATE TABLE `ecs_user_bonus`;
TRUNCATE TABLE `ecs_user_card`;
TRUNCATE TABLE `ecs_user_card_type`;
TRUNCATE TABLE `ecs_user_cashout`;
TRUNCATE TABLE `ecs_user_connect`;
TRUNCATE TABLE `ecs_user_connect_app`;
TRUNCATE TABLE `ecs_user_feed`;
TRUNCATE TABLE `ecs_user_moneylog`;
TRUNCATE TABLE `ecs_user_pointlog`;
TRUNCATE TABLE `ecs_user_rank`;
TRUNCATE TABLE `ecs_user_transfer_record`;
TRUNCATE TABLE `ecs_virtual_card`;
TRUNCATE TABLE `ecs_volume_price`;
TRUNCATE TABLE `ecs_vote`;
TRUNCATE TABLE `ecs_vote_log`;
TRUNCATE TABLE `ecs_vote_option`;
TRUNCATE TABLE `ecs_wangdianqiugou`;
TRUNCATE TABLE `ecs_wechat_authcode`;
TRUNCATE TABLE `ecs_wholesale`;
TRUNCATE TABLE `ecs_zhaoshang`;

建站咨询

咨询热线

微信交流

返回顶部