MySQL——case when语句测试

CREATE TABLE student (
    id INT PRIMARY KEY AUTO_INCREMENT,
    createDate DATE NOT NULL,
    userName VARCHAR(255) NOT NULL,
    phone VARCHAR(20),
    age INT,
    sex ENUM('M','F','O') NOT NULL,
    introduce TEXT
);

SELECT 
    id,
    userName,
    age,
    CASE sex
        WHEN 'M' THEN '男性'
        WHEN 'F' THEN '女性'
        WHEN 'O' THEN '泰国人'
        ELSE '未知' -- 可选，为了处理除'M', 'F', 'O'之外的其他潜在情况
    END AS displaySex,
    introduce
FROM 
    student
LIMIT 
    9527;