Mysql 跨库 迁移数据

1. Insert

insert into 目标库.device(name)
select name from 源库.device;

2. Update

update 目标库.device a,源库.device b set a.name = b.name