mysql 合并表格数据

-- user_basic 表
CREATE TABLE user_basic (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

-- user_ext 表
CREATE TABLE user_ext (
    id INT PRIMARY KEY,
    address VARCHAR(100),
    phone VARCHAR(20)
);

ALTER TABLE user_basic ADD COLUMN address VARCHAR(100), ADD COLUMN phone VARCHAR(20);

INSERT INTO user_basic (id, name, email, address, phone)
SELECT ub.id, ub.name, ub.email, ue.address, ue.phone
FROM user_basic ub
JOIN user_ext ue ON ub.id = ue.id;

-- log_202301 表
CREATE TABLE log_202301 (
    id INT PRIMARY KEY,
    message VARCHAR(255),
    timestamp DATETIME
);

-- log_202302 表
CREATE TABLE log_202302 (
    id INT PRIMARY KEY,
    message VARCHAR(255),
    timestamp DATETIME
);

CREATE TABLE merged_logs AS
SELECT * FROM log_202301
UNION
SELECT * FROM log_202302;