找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 116|回复: 7

数据库手动清档sql

[复制链接]

644

主题

3990

回帖

1万

积分

登峰造极

积分
14432
发表于 2024-10-18 09:51:23 | 显示全部楼层 |阅读模式
虽然 有很多工具都带清档功能,不过我喜欢手动sql,我找到工具源码,把sql搞出来了。有两处不明白希望大神 能指点下。
不太明白 d_guild.guild_info; 这一句是干嘛的。
delete from taiwan_cain_2nd.postal;
d_guild.guild_info;
delete from d_guild.guild_introduce;
delete from d_guild.guild_skill;
delete from d_guild.guild_visit;
delete from d_guild.guild_bbs;
delete from d_guild.guild_grade_log;
delete from d_guild.guild_join_list;
delete from d_guild.guild_member;
delete from d_guild.guild_member_introduce;
delete from d_guild.guild_recommend;
delete from d_guild.power_war_user_rank;
delete from d_taiwan.accounts;
delete from d_taiwan.accountss;
delete from d_taiwan.account_cerashop_restrict;
delete from d_taiwan.bad_user;
delete from d_taiwan.bak_m_id_20130426_2;
delete from d_taiwan.check_pick_up_random_option_item;
delete from d_taiwan.dnf_charac_mov;
delete from d_taiwan.dnf_event_address;
delete from d_taiwan.dnf_event_entry_notuse;
delete from d_taiwan.dnf_event_log;
delete from d_taiwan.dnf_event_prize;
delete from d_taiwan.dnf_master_charac;
delete from d_taiwan.dnf_story;
delete from d_taiwan.dnf_testr_m_id;
delete from d_taiwan.event_aradlotto_0809_entry;
delete from d_taiwan.event_charac_mov_1th;
delete from d_taiwan.event_charac_mov_1th_entry;
delete from d_taiwan.event_goldcard_entry1;
delete from d_taiwan.event_goldcard_entry2;
delete from d_taiwan.event_goldcard_info;
delete from d_taiwan.event_mage_2years;
delete from d_taiwan.event_newmember0709_entry;
delete from d_taiwan.event_pandora_entry_200905;
delete from d_taiwan.event_quest_party_member_web;
delete from d_taiwan.event_quizquiz_stamp;
delete from d_taiwan.event_skill2025_entry;
delete from d_taiwan.event_tower_entry;
delete from d_taiwan.event_webmoneystamp_entry;
delete from d_taiwan.event_webmoneystamp_item;
delete from d_taiwan.gm_manifest_notuse;
delete from d_taiwan.guild_bbs;
delete from d_taiwan.guild_member;
delete from d_taiwan.guild_member_introduce;
delete from d_taiwan.guild_recommend;
delete from d_taiwan.limit_create_character;
delete from d_taiwan.member_broadcast;
delete from d_taiwan.member_captcha_info;
delete from d_taiwan.member_handicap;
delete from d_taiwan.member_info;
delete from d_taiwan.member_info_detail;
delete from d_taiwan.member_info_euckr;
delete from d_taiwan.member_info_mileage;
delete from d_taiwan.member_info_old;
delete from d_taiwan.member_info_utf8;
delete from d_taiwan.member_join_info;
delete from d_taiwan.member_miles;
delete from d_taiwan.member_mouse_sms;
delete from d_taiwan.member_passwd_mod;
delete from d_taiwan.member_premium_history;
delete from d_taiwan.member_premium_notuse;
delete from d_taiwan.member_punish_hack;
delete from d_taiwan.member_punish_hack_history;
delete from d_taiwan.member_punish_info;
delete from d_taiwan.member_punish_info_history;
delete from d_taiwan.member_punish_info_history_2012;
delete from d_taiwan.member_punish_info_history_2013;
delete from d_taiwan.member_safe_ensure;
delete from d_taiwan.member_safe_ensure_history;
delete from d_taiwan.member_security_grade;
delete from d_taiwan.member_white_account;
delete from d_taiwan.m_withdraw;
delete from d_taiwan.notice;
delete from d_taiwan.passwd_mod_entry;
delete from d_taiwan.pswd_qstion_direct;
delete from d_taiwan.pu_user_list;
delete from d_taiwan.tme_charac;
delete from d_taiwan.tmp_charac;
delete from d_taiwan.under_age_consent;
delete from d_taiwan.under_billing_confirm;
delete from d_taiwan.user_ban;
delete from d_technical_report.captcha_invalid_request;
delete from d_technical_report.powerwar_lag;
delete from d_technical_report.powerwar_loading;
delete from d_technical_report.spec_info;
delete from d_technical_report.ting_user_account;
delete from d_technical_report.ting_user_spec;
delete from taiwan_cain.account_cargo;
delete from taiwan_cain.aura_avatar_option;
delete from taiwan_cain.bak_20130408;
delete from taiwan_cain.bak_50_mid;
delete from taiwan_cain.bak_charac_info_20130219;
delete from taiwan_cain.bak_charac_info_20130228;
delete from taiwan_cain.bak_charac_info_20130228_2;
delete from taiwan_cain.bak_charac_info_20130228_3;
delete from taiwan_cain.bak_charac_info_20130326_1_1;
delete from taiwan_cain.bak_charac_info_20130326_1_2;
delete from taiwan_cain.bak_charac_no_20130405;
delete from taiwan_cain.bak_member_info_20130228;
delete from taiwan_cain.bak_member_info_20130326;
delete from taiwan_cain.bak_mid_20130408;
delete from taiwan_cain.bak_m_id_20130405;
delete from taiwan_cain.bak_m_id_20130408;
delete from taiwan_cain.bak_m_id_20130424_ccb;
delete from taiwan_cain.bak_m_id_cbt;
delete from taiwan_cain.bak_m_id_cbt_2;
delete from taiwan_cain.bak_m_id_cbt_3;
delete from taiwan_cain.bak_m_id_charac_no_20130408;
delete from taiwan_cain.bak_pvp_20130221;
delete from taiwan_cain.bak_pvp_20130222;
delete from taiwan_cain.bak_pvp_20130223;
delete from taiwan_cain.bak_pvp_20130224;
delete from taiwan_cain.bak_result_20130408;
delete from taiwan_cain.bak_result_50;
delete from taiwan_cain.bak_sooya_result_20130405;
delete from taiwan_cain.charac_achievement;
delete from taiwan_cain.charac_action_point;
delete from taiwan_cain.charac_best_record;
delete from taiwan_cain.charac_blood_best_record;
delete from taiwan_cain.charac_blood_dungeon_reward;
delete from taiwan_cain.charac_blood_inout;
delete from taiwan_cain.charac_cerashop_restrict;
delete from taiwan_cain.charac_dimension_inout;
delete from taiwan_cain.charac_dimension_inout_20130613;
delete from taiwan_cain.charac_dungeon;
delete from taiwan_cain.charac_dungeon_test;
delete from taiwan_cain.charac_expert_job;
delete from taiwan_cain.charac_friends;
delete from taiwan_cain.charac_housing_info;
delete from taiwan_cain.charac_housing_tree_info;
delete from taiwan_cain.charac_housing_water_history;
delete from taiwan_cain.charac_info;
delete from taiwan_cain.charac_item_stat;
delete from taiwan_cain.charac_kill_monster_info;
delete from taiwan_cain.charac_link_bonus;
delete from taiwan_cain.charac_link_message;
delete from taiwan_cain.charac_manage_info;
delete from taiwan_cain.charac_members;
delete from taiwan_cain.charac_npc;
delete from taiwan_cain.charac_option;
delete from taiwan_cain.charac_quest;
delete from taiwan_cain.charac_quest_shop;
delete from taiwan_cain.charac_ridable_stat;
delete from taiwan_cain.charac_stat;
delete from taiwan_cain.charac_titlebook;
delete from taiwan_cain.charac_tower_despair;
delete from taiwan_cain.charac_tower_despair_apc;
delete from taiwan_cain.charac_tower_rank;
delete from taiwan_cain.charac_tower_rank_top5;
delete from taiwan_cain.charac_tower_record;
delete from taiwan_cain.charac_trade_limit_info;
delete from taiwan_cain.charac_view;
delete from taiwan_cain.charac_view_act8;
delete from taiwan_cain.eco_point;
delete from taiwan_cain.event_1106_idol_bring_up;
delete from taiwan_cain.event_additional_condition_info;
delete from taiwan_cain.event_conditionable_info;
delete from taiwan_cain.event_condition_info;
delete from taiwan_cain.event_detective_goblin;
delete from taiwan_cain.event_dungeon_clear;
delete from taiwan_cain.event_levelup_support;
delete from taiwan_cain.event_used_fatigue_at_mage;
delete from taiwan_cain.event_visit_room_info;
delete from taiwan_cain.ip_info;
delete from taiwan_cain.item_making_skill_info;
delete from taiwan_cain.member_booster_gage;
delete from taiwan_cain.member_dungeon;
delete from taiwan_cain.new_charac_quest;
delete from taiwan_cain.pvp_grade_expand;
delete from taiwan_cain.pvp_result;
delete from taiwan_cain.test_sooya;
delete from taiwan_cain_2nd.bak_charac_no_20130221;
delete from taiwan_cain_2nd.bak_charac_no_20130222;
delete from taiwan_cain_2nd.bak_charac_no_20130222_1;
delete from taiwan_cain_2nd.bak_charac_no_20130223;
delete from taiwan_cain_2nd.bak_charac_no_20130223_1;
delete from taiwan_cain_2nd.bak_charac_no_20130224;
delete from taiwan_cain_2nd.bak_letter;
delete from taiwan_cain_2nd.bak_letter_20130409;
delete from taiwan_cain_2nd.charac_advance_altar;
delete from taiwan_cain_2nd.charac_black_info;
delete from taiwan_cain_2nd.charac_black_list;
delete from taiwan_cain_2nd.charac_event_items;
delete from taiwan_cain_2nd.charac_inven_expand;
delete from taiwan_cain_2nd.charac_item_lock_info;
delete from taiwan_cain_2nd.combo_skill;
delete from taiwan_cain_2nd.combo_skill_2nd;
delete from taiwan_cain_2nd.creature_items;
delete from taiwan_cain_2nd.creature_items_del;
delete from taiwan_cain_2nd.fair_pvp_score;
delete from taiwan_cain_2nd.inventory;
delete from taiwan_cain_2nd.letter;
delete from taiwan_cain_2nd.letter_del;
delete from taiwan_cain_2nd.member_avatar_coin;
delete from taiwan_cain_2nd.skill;
delete from taiwan_cain_2nd.skill_fair_pvp;
delete from taiwan_cain_2nd.skill_lethe;
delete from taiwan_cain_2nd.store;
delete from taiwan_cain_2nd.tmp_charac;
delete from taiwan_cain_2nd.user_items;
delete from taiwan_cain_2nd.user_items_20130502;
delete from taiwan_cain_2nd.user_items_del;
delete from taiwan_cain_2nd.user_items_history;
delete from taiwan_cain_2nd.user_items_work;
delete from taiwan_cain_2nd.village_attack_dungeon;
delete from taiwan_cain_2nd.village_ticket;
delete from taiwan_cain_log.dnf_hack_log;
delete from taiwan_cain_log.dnf_hack_log_del;
delete from taiwan_cain_log.dnf_party_ping_history;
delete from taiwan_cain_log.dnf_party_ping_history_pvp;
delete from taiwan_cain_log.dnf_party_result_history;
delete from taiwan_cain_log.dnf_party_result_history_pvp;
delete from taiwan_cain_log.dnf_party_stat_history;
delete from taiwan_cain_log.dnf_proxy_log;
delete from taiwan_cain_log.event_goldcard_log;
delete from taiwan_cain_log.event_quest_party_member;
delete from taiwan_cain_log.login_account;
delete from taiwan_cain_log.login_view_log;
delete from taiwan_cain_log.log_acquire_item;
delete from taiwan_cain_log.log_arad_event_stat;
delete from taiwan_cain_log.log_charac_money;
delete from taiwan_cain_log.log_eco_point;
delete from taiwan_cain_log.log_item_develop;
delete from taiwan_cain_log.log_lucky_ticket_stat;
delete from taiwan_cain_log.log_mercenary;
delete from taiwan_cain_log.log_playtime;
delete from taiwan_cain_log.log_police_chatting;
delete from taiwan_cain_log.member_environment_entry;
delete from taiwan_cain_log.reliable_member_log;
delete from taiwan_cain_log.trade_gold_daily;
delete from taiwan_cain_log.trade_gold_rank;
delete from taiwan_cain_web.guild_memo;
delete from taiwan_game_event.cleanup_penalty_log;
delete from taiwan_game_event.cleanup_user_data;
delete from taiwan_game_event.dnf_event_entry_notuse;
delete from taiwan_game_event.event_1107_avenger_plan;
delete from taiwan_game_event.event_1112_at_mage_12up;
delete from taiwan_game_event.event_1202_fatigue_attendance;
delete from taiwan_game_event.event_1207_growthweapon;
delete from taiwan_game_event.event_1208_bingo;
delete from taiwan_game_event.event_1306_account_reward;
delete from taiwan_game_event.event_1306_account_reward_2nd;
delete from taiwan_game_event.event_account_fatigue;
delete from taiwan_game_event.event_account_fatigue_reward;
delete from taiwan_game_event.event_attendance_check_info;
delete from taiwan_game_event.event_at_fighter_doll;
delete from taiwan_game_event.event_clear_quest;
delete from taiwan_game_event.event_create_charac;
delete from taiwan_game_event.event_create_dnf_user;
delete from taiwan_game_event.event_give_title_twn;
delete from taiwan_game_event.event_hero_mission_data;
delete from taiwan_game_event.event_ingame_history;
delete from taiwan_game_event.event_login_reward_in_list;
delete from taiwan_game_event.event_minority_point;
delete from taiwan_game_event.event_ontime_user;
delete from taiwan_game_event.event_purchase_cnt;
delete from taiwan_game_event.event_return_user;
delete from taiwan_game_event.event_reward_item_arad;
delete from taiwan_game_event.event_stamp_checkinfo;
delete from taiwan_game_event.event_stamp_daily;
delete from taiwan_game_event.event_stay_time_charac;
delete from taiwan_game_event.event_valentine_vote_info;
delete from taiwan_game_event.event_valentine_vote_info_old;
delete from taiwan_game_event.login_common;
delete from taiwan_game_event.mobile_auth_reward_tw;
delete from taiwan_game_event.pcroom_daily_reward_tw;
delete from taiwan_game_event.return_user;
delete from taiwan_login.allow_proxy_user;
delete from taiwan_login.auto_punish_first_user;
delete from taiwan_login.auto_punish_second_log;
delete from taiwan_login.auto_punish_second_user;
delete from taiwan_login.churn_member_info;
delete from taiwan_login.churn_reward_history_201506;
delete from taiwan_login.churn_reward_history_201507;
delete from taiwan_login.dnf_event_entry;
delete from taiwan_login.gm_manifest;
delete from taiwan_login.human_certify_try_count;
delete from taiwan_login.login_account_1;
delete from taiwan_login.login_account_2;
delete from taiwan_login.login_account_3;
delete from taiwan_login.login_history;
delete from taiwan_login.log_growth;
delete from taiwan_login.member_captcha_info;
delete from taiwan_login.member_doubt_trade;
delete from taiwan_login.member_game_option;
delete from taiwan_login.member_game_option_1;
delete from taiwan_login.member_key_option;
delete from taiwan_login.member_login;
delete from taiwan_login.member_login_backup;
delete from taiwan_login.member_mousepass;
delete from taiwan_login.member_mousepass_history;
delete from taiwan_login.member_mousepass_history_201506;
delete from taiwan_login.member_mousepass_history_201507;
delete from taiwan_login.member_play_info;
delete from taiwan_login.member_play_info_20130502;
delete from taiwan_login.member_play_info_del;
delete from taiwan_login.member_premium;
delete from taiwan_login.member_premium_old;
delete from taiwan_login.member_security_card;
delete from taiwan_login.member_security_card_history;
delete from taiwan_login.nexon_none_memner_restriction;
delete from taiwan_login.village_attacked_charac_point_rank;
delete from taiwan_login_play.member_key_option;
delete from taiwan_main_web.arad_news;
delete from taiwan_main_web.arad_news_comment;
delete from taiwan_main_web.arad_news_namecard_board_list;
delete from taiwan_main_web.arad_news_namecard_config;
delete from taiwan_main_web.arad_news_recom;
delete from taiwan_main_web.arad_news_tail_comment;
delete from taiwan_main_web.bad_user;
delete from taiwan_main_web.bug_report;
delete from taiwan_main_web.community_discussion;
delete from taiwan_main_web.community_discussion_asking_log;
delete from taiwan_main_web.community_discussion_comment;
delete from taiwan_main_web.community_discussion_recom;
delete from taiwan_main_web.discussion;
delete from taiwan_main_web.discussion_comment;
delete from taiwan_main_web.discussion_entry;
delete from taiwan_main_web.dnf_item_comment;
delete from taiwan_main_web.dnf_league_bbs_comments;
delete from taiwan_main_web.dnf_league_bbs_contents;
delete from taiwan_main_web.dnf_league_player_info;
delete from taiwan_main_web.dnf_magazine_quiz;
delete from taiwan_main_web.dnf_school_charac;
delete from taiwan_main_web.dnf_security_tip_quiz;
delete from taiwan_main_web.download_library;
delete from taiwan_main_web.event_dnf_3year_comment;
delete from taiwan_main_web.event_dnf_3year_feel;
delete from taiwan_main_web.focus_comment;
delete from taiwan_main_web.focus_game_comment;
delete from taiwan_main_web.free_charge_list;
delete from taiwan_main_web.gen_bbs;
delete from taiwan_main_web.guarder_info;
delete from taiwan_main_web.guild_bbs;
delete from taiwan_main_web.guild_recommend;
delete from taiwan_main_web.id_pass;
delete from taiwan_main_web.intensive_discussion;
delete from taiwan_main_web.intensive_discussion_comment;
delete from taiwan_main_web.intensive_discussion_comment_recom;
delete from taiwan_main_web.intensive_discussion_comment_reply;
delete from taiwan_main_web.knowcafe_gift_entry;
delete from taiwan_main_web.knowcafe_job;
delete from taiwan_main_web.knowcafe_job_comment;
delete from taiwan_main_web.knowcafe_member_point;
delete from taiwan_main_web.knowcafe_plan;
delete from taiwan_main_web.knowcafe_plan_comment;
delete from taiwan_main_web.knowcafe_qa;
delete from taiwan_main_web.knowcafe_qa_comment;
delete from taiwan_main_web.knowcafe_qa_old;
delete from taiwan_main_web.knowcafe_rank;
delete from taiwan_main_web.knowcafe_tip;
delete from taiwan_main_web.knowcafe_tip_comment;
delete from taiwan_main_web.knowledge;
delete from taiwan_main_web.knowledge_comment;
delete from taiwan_main_web.knowledge_test;
delete from taiwan_main_web.knowl_bbs;
delete from taiwan_main_web.knowstandby;
delete from taiwan_main_web.knowstandby_comment;
delete from taiwan_main_web.log_3month_stop_web;
delete from taiwan_main_web.magazine;
delete from taiwan_main_web.magazine_comment;
delete from taiwan_main_web.member_coin;
delete from taiwan_main_web.my_guestbook0;
delete from taiwan_main_web.newmagazine;
delete from taiwan_main_web.newmagazine_comment;
delete from taiwan_main_web.newmagazine_recomm;
delete from taiwan_main_web.newmagazine_ucc;
delete from taiwan_main_web.newmagazine_ucc_comment;
delete from taiwan_main_web.newyear2008_comment;
delete from taiwan_main_web.notice;
delete from taiwan_main_web.notice_comment;
delete from taiwan_main_web.notice_comment_realradio_view;
delete from taiwan_main_web.opencast_content;
delete from taiwan_main_web.opencast_content_sub;
delete from taiwan_main_web.opencast_editor;
delete from taiwan_main_web.opencast_member_info;
delete from taiwan_main_web.opencast_stat;
delete from taiwan_main_web.opencast_subscribe;
delete from taiwan_main_web.penpic;
delete from taiwan_main_web.penpic2;
delete from taiwan_main_web.penpic2_comment;
delete from taiwan_main_web.penpic2_entry;
delete from taiwan_main_web.penpic3;
delete from taiwan_main_web.penpic3_comment;
delete from taiwan_main_web.penpic3_entry;
delete from taiwan_main_web.penpic4;
delete from taiwan_main_web.penpic4_comment;
delete from taiwan_main_web.penpic4_entry;
delete from taiwan_main_web.penpic_comment;
delete from taiwan_main_web.penpic_entry;
delete from taiwan_main_web.plan;
delete from taiwan_main_web.plan_comment;
delete from taiwan_main_web.powerclub_discussion;
delete from taiwan_main_web.powerclub_discussion_bbs;
delete from taiwan_main_web.powerclub_discussion_comment;
delete from taiwan_main_web.powerclub_discussion_comment_recom;
delete from taiwan_main_web.powerclub_discussion_comment_reply;
delete from taiwan_main_web.protect_acc_release_log;
delete from taiwan_main_web.rdar0;
delete from taiwan_main_web.rdar0_comment;
delete from taiwan_main_web.rdar0_myisam;
delete from taiwan_main_web.rdar6;
delete from taiwan_main_web.rdar6_comment;
delete from taiwan_main_web.rdar_beta_tester;
delete from taiwan_main_web.realdrama_comment;
delete from taiwan_main_web.realradio;
delete from taiwan_main_web.realradio_1year_comment;
delete from taiwan_main_web.realradio_comment;
delete from taiwan_main_web.realradio_event;
delete from taiwan_main_web.realradio_event_comment;
delete from taiwan_main_web.realradio_event_comment_view;
delete from taiwan_main_web.repl_bbs;
delete from taiwan_main_web.repl_comment;
delete from taiwan_main_web.repl_recomm;
delete from taiwan_main_web.security_tip;
delete from taiwan_main_web.security_tip_comment;
delete from taiwan_main_web.skill_dictionary_comment;
delete from taiwan_main_web.skill_dictionary_estimate_log;
delete from taiwan_main_web.tcg_free;
delete from taiwan_main_web.tcg_free_comment;
delete from taiwan_main_web.tcg_grand;
delete from taiwan_main_web.tcg_public_info;
delete from taiwan_main_web.tcg_public_info_comment;
delete from taiwan_main_web.tcg_rule;
delete from taiwan_main_web.tcg_rule_comment;
delete from taiwan_main_web.tcg_tune;
delete from taiwan_main_web.tcg_tune_comment;
delete from taiwan_main_web.tmp_gan_member;
delete from taiwan_main_web.ucc_public_info;
delete from taiwan_main_web.ucc_public_info_comment;
delete from taiwan_main_web.ucc_user_writers;
delete from taiwan_main_web.wedding_memo;
delete from taiwan_main_web.world_cup_event_comment;
delete from taiwan_main_web.world_cup_event_rank;
delete from taiwan_main_web.world_cup_event_temp;
delete from taiwan_mng_manager.account_cargo_mod;
delete from taiwan_mng_manager.avatar_mod;
delete from taiwan_mng_manager.charac_avatar_mod;
delete from taiwan_mng_manager.charac_cargo_mod;
delete from taiwan_mng_manager.charac_creature_inven_mod;
delete from taiwan_mng_manager.charac_housing_mod;
delete from taiwan_mng_manager.charac_housing_tree_mod;
delete from taiwan_mng_manager.charac_info_mod;
delete from taiwan_mng_manager.charac_inven_mod;
delete from taiwan_mng_manager.charac_titlebook_mod;
delete from taiwan_mng_manager.member_mousepass_modify;
delete from taiwan_mng_manager.member_premium_mod;
delete from taiwan_mng_manager.member_reference;
delete from taiwan_mng_manager.oneclick_charac_avatar_mod;
delete from taiwan_prod.prod_buy_user;
delete from taiwan_prod.prod_sale_entry_124;
delete from taiwan_prod.prod_sale_entry_131;
delete from taiwan_prod.prod_sale_entry_132;
delete from taiwan_prod.prod_sale_entry_133;
delete from taiwan_prod.prod_sale_entry_134;
delete from taiwan_prod.pu_user_list;
delete from taiwan_se_event.event_1112_ontime_reward_user;
delete from taiwan_se_event.event_1112_ontime_user_0;
delete from taiwan_se_event.event_1112_ontime_user_1;
delete from taiwan_se_event.event_1112_ontime_user_2;
delete from taiwan_se_event.event_1112_ontime_user_3;
delete from taiwan_se_event.event_1112_ontime_user_4;
delete from taiwan_se_event.event_1112_ontime_user_5;
delete from taiwan_se_event.event_1112_ontime_user_6;
delete from taiwan_se_event.event_1112_ontime_user_7;
delete from taiwan_se_event.event_1112_ontime_user_8;
delete from taiwan_se_event.event_1112_ontime_user_9;
delete from tw.accounts;
delete from tw.account_cerashop_restrict;
delete from tw.bad_user;
delete from tw.bak_m_id_20130426_2;
delete from tw.check_pick_up_random_option_item;
delete from tw.dnf_charac_mov;
delete from tw.dnf_event_address;
delete from tw.dnf_event_entry_notuse;
delete from tw.dnf_event_log;
delete from tw.dnf_event_prize;
delete from tw.dnf_master_charac;
delete from tw.dnf_story;
delete from tw.dnf_testr_m_id;
delete from tw.event_aradlotto_0809_entry;
delete from tw.event_charac_mov_1th;
delete from tw.event_charac_mov_1th_entry;
delete from tw.event_goldcard_entry1;
delete from tw.event_goldcard_entry2;
delete from tw.event_goldcard_info;
delete from tw.event_mage_2years;
delete from tw.event_newmember0709_entry;
delete from tw.event_pandora_entry_200905;
delete from tw.event_quest_party_member_web;
delete from tw.event_quizquiz_stamp;
delete from tw.event_skill2025_entry;
delete from tw.event_tower_entry;
delete from tw.event_webmoneystamp_entry;
delete from tw.event_webmoneystamp_item;
delete from tw.gm_manifest_notuse;
delete from tw.guild_bbs;
delete from tw.guild_member;
delete from tw.guild_member_introduce;
delete from tw.guild_recommend;
delete from tw.limit_create_character;
delete from tw.member_broadcast;
delete from tw.member_captcha_info;
delete from tw.member_handicap;
delete from tw.member_info;
delete from tw.member_info_detail;
delete from tw.member_info_euckr;
delete from tw.member_info_mileage;
delete from tw.member_info_old;
delete from tw.member_info_utf8;
delete from tw.member_join_info;
delete from tw.member_miles;
delete from tw.member_mouse_sms;
delete from tw.member_passwd_mod;
delete from tw.member_premium_history;
delete from tw.member_premium_notuse;
delete from tw.member_punish_hack;
delete from tw.member_punish_hack_history;
delete from tw.member_punish_info;
delete from tw.member_punish_info_history;
delete from tw.member_punish_info_history_2012;
delete from tw.member_punish_info_history_2013;
delete from tw.member_safe_ensure;
delete from tw.member_safe_ensure_history;
delete from tw.member_security_grade;
delete from tw.member_white_account;
delete from tw.m_withdraw;
delete from tw.notice;
delete from tw.passwd_mod_entry;
delete from tw.pswd_qstion_direct;
delete from tw.pu_user_list;
delete from tw.tme_charac;
delete from tw.tmp_charac;
delete from tw.under_age_consent;
delete from tw.under_billing_confirm;
delete from tw.user_ban;
delete from taiwan_billing.cash_cera;
delete from taiwan_billing.cash_cera_point;
delete from taiwan_billing.cash_transaction;
delete from taiwan_billing.cs_table2;
delete from taiwan_billing.log_error_history;
delete from taiwan_billing.log_gift_history;
delete from taiwan_billing.log_item_refund_history;
delete from taiwan_billing.log_point_history;
delete from taiwan_billing.log_purchase_history;
delete from taiwan_billing.log_recharge_history;
delete from taiwan_billing.log_refund_history;
delete from taiwan_billing.log_transaction_history;
ALTER TABLE d_taiwan.accounts AUTO_INCREMENT = 1;
ALTER TABLE taiwan_cain.charac_info AUTO_INCREMENT = 1
回复

使用道具 举报

644

主题

3990

回帖

1万

积分

登峰造极

积分
14432
 楼主| 发表于 2024-10-18 09:51:53 | 显示全部楼层
1楼
回复

使用道具 举报

669

主题

4174

回帖

1万

积分

登峰造极

积分
15168
发表于 2024-10-18 09:52:13 | 显示全部楼层
多谢大佬分享
回复

使用道具 举报

669

主题

4174

回帖

1万

积分

登峰造极

积分
15168
发表于 2024-10-18 09:52:51 | 显示全部楼层
不明觉厉

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?立即注册

×
回复

使用道具 举报

669

主题

4174

回帖

1万

积分

登峰造极

积分
15168
发表于 2024-10-18 09:53:26 | 显示全部楼层
好长……
回复

使用道具 举报

705

主题

4207

回帖

1万

积分

登峰造极

积分
15441
发表于 2024-10-18 09:54:04 | 显示全部楼层
直接truncate更快

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?立即注册

×
回复

使用道具 举报

644

主题

3990

回帖

1万

积分

登峰造极

积分
14432
 楼主| 发表于 2024-10-18 09:54:19 | 显示全部楼层
马克
回复

使用道具 举报

705

主题

4207

回帖

1万

积分

登峰造极

积分
15441
发表于 2024-10-18 09:55:03 | 显示全部楼层
大佬 麻烦请问一下 这个脚本执行完需要重启服务吗
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表