--表结构相等 insert into A select * from B where B.type='A'; --部分字段 insert into A(id,name) select B.id,B.name from B where B.type='A';
--表结构相等 insert into A select * from B where B.type='A'; --部分字段 insert into A(id,name) select B.id,B.name from B where B.type='A';