mysql设置枚举类型

CREATE TABLE table_name (
    column_name ENUM('value1', 'value2', 'value3', ...)
);

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    gender ENUM('Male', 'Female', 'Other')
);

INSERT INTO users (name, gender) VALUES ('Alice', 'Female'); -- 合法
INSERT INTO users (name, gender) VALUES ('Bob', 'Unknown'); -- 非法，会报错

ALTER TABLE users MODIFY COLUMN gender ENUM('Male', 'Female', 'Other', 'Prefer Not to Say');

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    gender ENUM('Male', 'Female', 'Other')
);

-- 插入数据
INSERT INTO users (name, gender) VALUES ('Alice', 'Female');
INSERT INTO users (name, gender) VALUES ('Bob', 'Male');

-- 查询数据
SELECT * FROM users;