mysql连表添加数据

-- 创建 users 表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL
);

-- 创建 user_profiles 表
CREATE TABLE user_profiles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    bio TEXT,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 插入数据到 users 表
INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');

-- 获取刚插入的用户ID
SET @last_user_id = LAST_INSERT_ID();

-- 插入数据到 user_profiles 表
INSERT INTO user_profiles (user_id, bio) VALUES (@last_user_id, 'Software Engineer');

START TRANSACTION;

INSERT INTO users (username, email) VALUES ('jane_doe', 'jane@example.com');
SET @last_user_id = LAST_INSERT_ID();

INSERT INTO user_profiles (user_id, bio) VALUES (@last_user_id, 'Data Scientist');

COMMIT;