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,
    location VARCHAR(100),
    FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 使用事务处理多表插入数据
START TRANSACTION;

INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');
INSERT INTO user_profiles (user_id, bio, location) VALUES (LAST_INSERT_ID(), 'Software Engineer', 'New York');

COMMIT;

START TRANSACTION;

INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');
INSERT INTO user_profiles (user_id, bio, location) VALUES (LAST_INSERT_ID(), 'Software Engineer', 'New York');

COMMIT;

-- 设置合适的隔离级别
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

START TRANSACTION;

INSERT INTO users (username, email) VALUES ('john_doe', 'john@example.com');
INSERT INTO user_profiles (user_id, bio, location) VALUES (LAST_INSERT_ID(), 'Software Engineer', 'New督办');

COMMIT;