mysql合并2表数据文件

-- 创建示例表
CREATE TABLE table1 (id INT, name VARCHAR(255));
CREATE TABLE table2 (id INT, name VARCHAR(255));

-- 插入示例数据
INSERT INTO table1 VALUES (1, 'Alice'), (2, 'Bob');
INSERT INTO table2 VALUES (3, 'Charlie'), (4, 'David');

-- 合并表数据
INSERT INTO table1 (id, name)
SELECT id, name FROM table2;

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(255)
);

CREATE TABLE user_profiles (
    user_id INT,
    age INT,
    address VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 创建新表来存储合并后的数据
CREATE TABLE merged_users (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    age INT,
    address VARCHAR(255)
);

-- 插入合并后的数据
INSERT INTO merged_users (id, name, age, address)
SELECT u.id, u.name, up.age, up.address
FROM users u
LEFT JOIN user_profiles up ON u.id = up.user_id;