update db1.ec_role,db2.ec_role set db2.ec_role.nickname=db1.ec_role.nickname
where db1.ec_role.id=db2.ec_role.id and db1.ec_role.nickname like '%#_%' escape '#';
update db1.ec_role,db2.ec_role set db2.ec_role.nickname=db1.ec_role.nickname
where db1.ec_role.id=db2.ec_role.id and db1.ec_role.nickname like '%#_%' escape '#';
update db2.ec_role,db1.ec_role
set db2.ec_role.nickname = db1.ec_role.nickname
where 1 = 1
and db2.ec_role.id = db1.ec_role.id
and db2.ec_role.id in (select db1.ec_role.id from db1.ec_role where db1.ec_role.nickname like '%#_%' escape '#');