mysql表垂直分离

CREATE TABLE user_info (
    user_id INT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(100),
    password VARCHAR(100),
    address VARCHAR(200),
    config_key VARCHAR(50),
    config_value TEXT
);

CREATE TABLE user_basic_info (
    user_id INT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(100),
    password VARCHAR(100)
);

CREATE TABLE user_config_info (
    user_id INT,
    config_key VARCHAR(50),
    config_value TEXT,
    PRIMARY KEY (user_id, config_key),
    FOREIGN KEY (user_id) REFERENCES user_basic_info(user_id)
);

SELECT 
    ubi.user_id,
    ubi.username,
    ubi.email,
    ubi.password,
    uci.config_key,
    uci.config_value
FROM 
    user_basic_info ubi
JOIN 
    user_config_info uci ON ubi.user_id = uci.user_id
WHERE 
    ubi.user_id = 1;

INSERT INTO user_basic_info (user_id, username, email, password)
VALUES (1, 'john_doe', 'john@example.com', 'password123');

INSERT INTO user_config_info (user_id, config_key, config_value)
VALUES (1, 'theme', 'dark');

UPDATE user_config_info
SET config_value = 'light'
WHERE user_id = 1 AND config_key = 'theme';