MySQL合并两张有相同字段信息的表格

[墨子卿]

合并两张表格，情况如下
A表：
字段信息：ID，IOSIDFA，DID，IOSAD，TIME
B表：
字段信息：ID，AndroidIDFA，DID，IOSAD，TIME
想要合并成为表C
格式如下：
字段信息：ID，IDFA，DID，AD，TIME
IDFA包含IOSIDFA和AndroidIDFA
AD包含IOSAD和IOSAD

大致内容如图：

[IceIsabel]

select * from A union all select * from B

[ACMAIN_CHM]

insert into C
select ID,IOSIDFA,DID,IOSAD,TIME from A表
union all
select ID,AndroidIDFA,DID,IOSAD,TIME from B表

[带我飞的云]

insert into C
select ID,IOSIDFA,DID,IOSAD,TIME from A表
union all
select ID,AndroidIDFA,DID,IOSAD,TIME from B表

[墨子卿]

引用 2 楼 ACMAIN_CHM 的回复:

insert into C
select ID,IOSIDFA,DID,IOSAD,TIME from A表
union all
select ID,AndroidIDFA,DID,IOSAD,TIME from B表

大佬，好像不对呢，因为C表还没有建，先要建一张C表，然后再插入进入数据，这个咋搞呢

[带我飞的云]

insert into C
select ID,IOSIDFA,DID,IOSAD,TIME from A表
union all
select ID,AndroidIDFA,DID,IOSAD,TIME from B表