mysql数据库两个表合并

INSERT INTO new_table SELECT * FROM table1;
INSERT INTO new_table SELECT * FROM table2;

CREATE TABLE new_table (name VARCHAR(100), age INT);
ALTER TABLE new_table ADD COLUMN source VARCHAR(100);
UPDATE new_table SET source = 'table1' WHERE source IS NULL;
UPDATE new_table SET source = 'table2' WHERE source IS NULL;

CREATE TABLE new_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    age INT,
    address VARCHAR(100)
);
INSERT INTO new_table SELECT NULL, name, age, NULL FROM table1;
ALTER TABLE new_table ADD COLUMN source VARCHAR(100);
UPDATE new_table SET source = 'table1' WHERE source IS NULL;
INSERT INTO new_table SELECT NULL, name, NULL, address FROM table2;
UPDATE new_table SET source = 'table2' WHERE source IS NULL;