SQL 将一个表的部分数据复制到另一个表,字段结构不同。
复制收展SQLinsert into tableB (id,name,sex)select id_ as id,name_ as name,sex_ as sex from tableA;
insert into tableB (id,name,sex)select id_ as id,name_ as name,sex_ as sex from tableA;