心动冒险岛独家分享清理数据库垃圾的SQL执行语句

delete FROM where lastlogin<''2013-06-7 00:12:23'' 
delete FROM where banned=1
delete FROM characters where accountid not in(select id from )
delete FROM pets where petid not in (select petid from characters)


1.第一条语句 时间换成你要账号最后登陆时间。
2.第二条语句 删除被封的账号。
3.第三条语句 删除空账号的角色
4.第四句 删除空角色的宠物。