update db_game.t_user_mail set sendername= Concat(sendername,\'★\') WHERE sendername IN (SELECT name FROM db_game2.t_user);
update db_game.t_user_mail set recvname= Concat(recvname,\'★\') WHERE recvname IN (SELECT name FROM db_game2.t_user);
update db_game.t_student set studentname= Concat(studentname,\'★\') WHERE studentname IN (SELECT name FROM db_game2.t_user);
update db_game.t_teacher set teachername= Concat(teachername,\'★\') WHERE teachername IN (SELECT name FROM db_game2.t_user);
====================================第四步:开始将源数据合并到目标数据================================
开始合并:
使用Navicat for MySQL的数据传输方式:
将源帐号数据db_account通过直接传输的方式合并到db_account2,数据库物件只选t_account表格,其它的不用选
将源角色数据db_game通过直接传输的方式合并到db_game2,数据库物件取消t_user_dungeon_team,t_vars,t_war_area表格,其它全选
注意:传输数据前要将 高级菜单==>创建表 选项取消
====================================合并结束,db_account2与db_game2数据为最终一二区合并数据================================
by Siline 2010.7.1
(责任编辑:admin) |