MySQL - 加入2个表

CREATE TABLE new_table (
  id INT AUTO_INCREMENT PRIMARY KEY,
  column1 datatype,
  column2 datatype,
  column3 datatype,
  ...
)

INSERT INTO new_table (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM old_table1
UNION
SELECT column1, column2, column3, ...
FROM old_table2

DROP TABLE new_table;