这句SQL错在哪里了?
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