mysql 枚举类型查询

ENUM('value1', 'value2', ..., 'valueN')

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

SELECT * FROM users WHERE gender = 'Male';

SELECT * FROM users WHERE gender = 1;

INSERT INTO users (gender) VALUES ('Male'); -- 正确
INSERT INTO users (gender) VALUES ('Other'); -- 错误，'Other' 不在枚举定义中

from enum import Enum

class Gender(Enum):
    Male = 'Male'
    Female = 'Female'

# 插入数据
def insert_user(gender):
    if gender not in Gender:
        raise ValueError("Invalid gender")
    sql = "INSERT INTO users (gender) VALUES (%s)"
    cursor.execute(sql, (gender.value,))
    connection.commit()

# 查询数据
def get_users_by_gender(gender):
    sql = "SELECT * FROM users WHERE gender = %s"
    cursor.execute(sql, (gender.value,))
    return cursor.fetchall()