RoConfig/合服/mysql复制表.txt

REPLACE INTO ro21.role (
        uid,
        serverid,
        device_id,
        nick_name,
        base_level,
        create_date,
        last_login_date,
        map_level,
        max_fight_power,
        fight_power,
        active_code,
        open_id,
        sub_platform,
        tower_level,
        vip,
        money,
        zeny,
        total_recharge,
        ban_date,
        ban_chat_date,
        last_recharge_time)
SELECT uid,
       serverid,
       device_id,
       nick_name,
       base_level,
       create_date,
       last_login_date,
       map_level,
       max_fight_power,
       fight_power,
       active_code,
       open_id,
       sub_platform,
       tower_level,
       vip,
       money,
       zeny,
       total_recharge,
       ban_date,
       ban_chat_date,
       last_recharge_time
FROM ro22.role;