mysql合并表数据

SELECT DISTINCT column1, column2, ...
FROM (
    SELECT column1, column2, ...
    FROM table1
    UNION
    SELECT column1, column2, ...
    FROM table2
) AS combined_table;

SELECT column1, column2, ...
FROM (
    SELECT CAST(column1 AS datatype) AS column1, column2, ...
    FROM table1
    UNION
    SELECT CAST(column1 AS datatype) AS column1, column2, ...
    FROM table2
) AS combined_table;

CREATE TABLE table1 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE TABLE table2 (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE TABLE combined_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

INSERT INTO combined_table (id, name, age)
SELECT id, name, age
FROM table1
UNION
SELECT id, name, age
FROM table2;