mysql查询枚举字段

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

SELECT * FROM users WHERE gender = 'Male';

INSERT INTO users (name, gender) VALUES ('Alice', 'Female'); -- 正确
INSERT INTO users (name, gender) VALUES ('Bob', 'Unknown'); -- 错误

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    gender ENUM('Male', 'Female', 'Other') -- Male和Female是最常用的值
);

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

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

-- 查询数据
SELECT * FROM users WHERE gender = 'Male';