多选框mysql结构入库

-- 创建用户表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

-- 创建选项表
CREATE TABLE options (
    id INT AUTO_INCREMENT PRIMARY KEY,
    option_name VARCHAR(255) NOT NULL
);

-- 创建用户选择表
CREATE TABLE user_options (
    user_id INT,
    option_id INT,
    PRIMARY KEY (user_id, option_id),
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (option_id) REFERENCES options(id)
);

-- 插入示例数据
INSERT INTO users (name) VALUES ('Alice');
INSERT INTO options (option_name) VALUES ('Option1'), ('Option2'), ('Option3');

-- 查询用户选择
SELECT u.name, o.option_name
FROM users u
JOIN user_options uo ON u.id = uo.user_id
JOIN options o ON uo.option_id = o.id
WHERE u.id = 1;