INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
UNION ALL
);
------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
UNION ALL
) t;
------解决方案--------------------
把*全部换成字段名就可以了
------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
);
------解决方案--------------------
INSERT INTO data.d1
SELECT * FROM
(
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3
) t
或者
INSERT INTO data.d1
SELECT * FROM data.d2
UNION ALL
SELECT * FROM data.d3