1.一机多区合区SQL语句

update memb_info set servercode = 1 where servercode = 2

将servercode = 2改为1

2.删除所有 servercode = NULL 的帐号

DELETE FROM memb_info WHERE servercode is NULL

3.删除所有 servercode = 1的帐号

DELETE FROM memb_info WHERE servercode =1

4.批量删除少于2人盟

a: select g_name into guildbak from guildmember group by g_name having count(*)<2

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

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

5.查积分大与1000的

use muonline
select * from MEMB_INFO where jf > '1000'

6.查积分小与0的或为负数的

use muonline
select * from MEMB_INFO where jf < '0'

7.当积分小于0时，修复为0

use muonline
update memb_info set memb_info.jf = 0 where memb_info.jf < 0

8.删除申请帐号后从未上过线的

delete from memb_info where memb___id in (select memb___id from memb_stat)

9.通过身份正号码查帐号，同理可以推算出很多种查帐号和抓外挂玩家的办法

select * from memb_info where addr_deta='450537019145266255