MySQL 实现表到表的多行插入导入

相同结果表插入
mysql> insert into tbB select  * from tbA;

对应列插入
mysql> insert into tbB( Bcolumn1, Bcolumn2 ) select  Acolumn1, Acolumn2 from tbA;

限制条件插入
mysql> insert into tbB select  * from tbA where ...;
mysql> insert into tbB( Bcolumn1, Bcolumn2 ) select  Acolumn1, Acolumn2 from tbA where ...;

多表导入（可通过创建视图实现）
mysql> insert into tbB( Bcolumn1, Bcolumn2 ) select tbA.Acolumn1, tbC.Ccolumn1 from tbA, tbC where tbA.Acolumn1 = tbC.Ccolumn1;