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,
    address VARCHAR(255),
    phone VARCHAR(20),
    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, address, phone) VALUES (@last_user_id, '123 Main St', '555-1234');

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, address, phone) VALUES (@last_user_id, '456 Elm St', '555-5678');

COMMIT;

SET FOREIGN_KEY_CHECKS = 0;

-- 插入数据

SET FOREIGN_KEY_CHECKS = 1;