天堂大量刪除DB資料的語法!

1.打開SQL程式、開啟資料庫之後，按F6就會跳出一個提示字元的控制介面！

2.請再提示字元(>)右邊將小妹PO上來的部分複製、貼上，然後記得將每個指令集的[中文用途說明]刪除。

3.最後按下ENTER就可以了。

以下指令：
(執行命令之前記得將每個指令集的[中文用途說明]刪除)

--刪除低於Lv??級的人物(下面敘述中??請自行代入要刪除的等級)←這ㄍ就是用途說明記得刪除這行。
DELETE characters.* FROM `characters` WHERE `level` < '??';

--把沒有人物的空帳號清除
DELETE accounts.* from accounts
left join characters on accounts.login=characters.account_name
where characters.account_name is null;

--清除已被刪掉空角色的好友表單
DELETE character_buddys.* from character_buddys
left join characters on character_buddys.char_id=characters.objid
where characters.objid is null;
DELETE character_buddys.* from character_buddys
left join characters on character_buddys.buddy_id=characters.objid
where characters.objid is null;

--清除已刪掉人物的魔法狀態
DELETE character_buff.* from character_buff
left join characters on character_buff.char_obj_id=characters.objid
where characters.objid is null;

--清除已刪掉人物的身上物品資料
DELETE character_items.* from character_items
left join characters on character_items.char_id=characters.objid
where characters.objid is null;

--清除已刪掉人物的任務資料
DELETE character_quests.* from character_quests
left join characters on character_quests.char_id=characters.objid
where characters.objid is null;

--清除已刪掉人物的技能
DELETE character_skills.* from character_skills
left join characters on character_skills.char_obj_id=characters.objid
where characters.objid is null;

--清除已刪掉人物的記憶座標
DELETE character_teleport.* from character_teleport
left join characters on character_teleport.char_id=characters.objid
where characters.objid is null;

--把空帳號的倉庫刪掉(這裡請注意，只是針對沒有人物的空帳號起作用。)
DELETE character_warehouse.* from character_warehouse
left join accounts on character_warehouse.account_name=accounts.login
where accounts.login is null;

--清除已經不存在的寵物(只用這個命令之前請玩家將存放於倉庫保管的項圈取出，否則會使倉庫的項圈變成白項圈喔。)
DELETE pets.* from pets
left join character_items on pets.item_obj_id=character_items.id
where character_items.id is null;

--清除空血盟
DELETE clan_data.* from clan_data
left join characters on clan_data.leader_id=characters.objid
where characters.objid is null;

--清除空血盟倉庫
DELETE clan_warehouse.* from clan_warehouse
left join clan_data on clan_warehouse.clan_name=clan_data.clan_name
where clan_data.clan_name is null;

原出處 http://bbs.djorz.com/t153626.html 妞子媽咪