Question

mysql 如何将a,b,c 三张表的数据取出来按照time字段(timestamp类型)进行排序后导入 d表

a,b,c,d四张表的字段数量与类型全部相同，字段名称除了主键名称也都相同
如题，很急，谢谢各位！！

Answer 1

新建e表；

INSERT e
SELECT FROM a;
INSERT e
SELECT FROM b;
INSERT e
SELECT FROM c;

INSERT d

SELECT FROM e
ORDER BY e.time;

可惜十五分钟内回答的20分了；

Answer 2

insert into d ( 字段1,字段2,字段3,字段4, timestamp )
select 字段1,字段2,字段3,字段4, timestamp from a
union
select 字段1,字段2,字段3,字段4, timestamp from b
union
select 字段1,字段2,字段3,字段4, timestamp from c
order by timestamp