跨库导入数据:
insert into A库名.表名(a,b)select a ,b form B库名.表名
脚本
insert into authmanagesys.menu(CN_Menu_Name) SELECT Mobile FROM mini315.in_menber;
– 同一个数据库库数据导入
insert into 表名(a,b)select a ,b from 表名
脚本
insert into member(CustomerId,BrandId,) SELECT Id ,2 FROM customer;