mysql枚举法

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

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

INSERT INTO users (gender) VALUES ('Unknown'); -- 这将导致错误

ALTER TABLE users MODIFY COLUMN gender ENUM('Male', 'Female', 'Other', 'Unknown') DEFAULT 'Unknown';

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

ALTER TABLE users MODIFY COLUMN gender ENUM('Male', 'Female', 'Other');

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;