批量删除少于2人盟:

打开查询编辑器

1: select g_name into guildbak from guildmember group by g_name having count(*)<3

2:delete from guild where g_name in (select g_name from guildbak)

3:delete from guildmember where g_name in (select g_name from guildbak)

请大家切记本站:奇迹私服大全 HTTP://WWW.530IDC.COM