mysql 连表insert

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

CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    amount DECIMAL(10, 2),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (name) VALUES ('Alice'), ('Bob');
INSERT INTO orders (user_id, amount) VALUES
    ((SELECT id FROM users WHERE name = 'Alice'), 100.00),
    ((SELECT id FROM users WHERE name = 'Bob'), 200.00);

-- 先插入用户数据
INSERT INTO users (name) VALUES ('Alice'), ('Bob');

-- 再插入订单数据
INSERT INTO orders (user_id, amount) VALUES
    (1, 100.00),
    (2, 200.00);

START TRANSACTION;

INSERT INTO users (name) VALUES ('Alice'), ('Bob');
INSERT INTO orders (user_id, amount) VALUES
    (1, 100.00),
    (2, 200.00);

COMMIT;