mysql把一行拆成两行

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

CREATE TABLE user_details (
    id INT PRIMARY KEY,
    user_id INT,
    email VARCHAR(255),
    address VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (id, name) VALUES (1, 'Alice');
INSERT INTO users (id, name) VALUES (2, 'Bob');

INSERT INTO user_details (id, user_id, email, address) VALUES (1, 1, 'alice@example.com', '123 Main St');
INSERT INTO user_details (id, user_id, email, address) VALUES (2, 2, 'bob@example.com', '456 Elm St');

SELECT users.id, users.name, user_details.email, user_details.address
FROM users
JOIN user_details ON users.id = user_details.user_id;

START TRANSACTION;
INSERT INTO users (id, name) VALUES (3, 'Charlie');
INSERT INTO user_details (id, user_id, email, address) VALUES (3, 3, 'charlie@example.com', '789 Oak St');
COMMIT;

CREATE INDEX idx_user_id ON user_details(user_id);