直接用navicat_lite打开要合的区数据库，（比如要把2区合到1区，就打开2区的数据库） 

打开au_server_gs 使用查询，执行如下SQL：

(说明：5000是为了玩家id重复，加上去的，可以适当加大点的值！)

update player_appearance set player_id = player_id + 5000;

update player_macrosses set player_id = player_id + 5000;

update player_punishments set player_id = player_id + 5000;

update player_quests set player_id = player_id + 5000;

update player_recipes set player_id = player_id + 5000;

update player_settings set player_id = player_id + 5000;

update player_skills set player_id = player_id  + 5000;

update player_titles set playerid = playerid + 5000;

update players set id = id + 5000,name=concat('abc',name),account_name=concat('abc',account_name);

abc ：是重命名玩家角色名，在后面加上 abc

接着打开au_server_ls使用查询，执行如下SQL：

update account_data set id = id + 5000,name=concat('abc',name);

完成后导出数据库中下面的表。导出为sql文件，再导入到一区的au_server_gs数据中。

player_appearance

player_macrosses

player_punishments

player_quests

player_recipes

player_settings

player_skills

player_titles

players

导出account_data 中所有数据，同样，导入到一区的au_server_ls数据中。