CREATE TABLE table_a (ID INT)
INSERT INTO table_a VALUES (1)
CREATE TABLE table_b (ID INT)
INSERT INTO table_b VALUES (2)CREATE TABLE table_c AS SELECT * FROM table_a UNION ALL SELECT * FROM table_b
INSERT INTO table_a VALUES (1)
CREATE TABLE table_b (ID INT)
INSERT INTO table_b VALUES (2)CREATE TABLE table_c AS SELECT * FROM table_a UNION ALL SELECT * FROM table_b
UNION ALL SELECT * FROM tbldata2
UNION ALL SELECT * FROM tbldata3;用UNION ALL 或者UNION
select * from tbldata1
union
select * from tbldata2
union
select * from tbldata3;