mysql用set添加数据类型

CREATE TABLE example (
    id INT AUTO_INCREMENT PRIMARY KEY,
    hobbies SET('reading', 'sports', 'music', 'travel')
);

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    gender ENUM('male', 'female', 'other'),
    hobbies SET('reading', 'sports', 'music', 'travel')
);

-- 插入数据
INSERT INTO users (name, gender, hobbies) VALUES
('Alice', 'female', 'reading,sports'),
('Bob', 'male', 'music'),
('Charlie', 'other', 'travel');

-- 查询数据
SELECT * FROM users;

-- 错误的插入
INSERT INTO users (name, gender, hobbies) VALUES ('Dave', 'male', 'painting'); -- 'painting' 不在集合中

-- 正确的插入
INSERT INTO users (name, gender, hobbies) VALUES ('Dave', 'male', 'reading'); -- 'reading' 在集合中

-- 查询喜欢阅读的用户
SELECT * FROM users WHERE FIND_IN_SET('reading', hobbies);