MySQL case语句用法

DDL

CREATE TABLE schooldb (
    Id INT PRIMARY KEY AUTO_INCREMENT,
    createDate DATE,
    userName VARCHAR(255),
    phone VARCHAR(15),
    age INT,
    sex CHAR(2),
    introduce TEXT
);

DML

INSERT INTO schooldb (createDate, userName, phone, age, sex, introduce) VALUES
('2023-09-01', '张三', '13800138000', 18, '男', '热爱运动，性格开朗'),
('2023-09-02', '李四', '13900139000', 19, '女', '喜欢音乐，学习成绩优异'),
('2023-09-03', '王五', '13700137000', 20, '男', '擅长绘画，多次获奖'),
('2023-09-04', '赵六', '13600136000', 18, '女', '文静内向，喜欢阅读'),
('2023-09-05', '孙七', '13500135000', 19, '男', '热爱科技，熟悉多种编程语言'),
('2023-09-06', '周八', '13400134000', 20, '女', '舞蹈社团成员，多次参加演出'),
('2023-09-07', '吴九', '13300133000', 18, '男', '热爱篮球，校队主力');

DQL

SELECT 
    Id,
    createDate,
    userName,
    phone,
    age,
    sex,
    introduce,
    CASE 
        WHEN sex = '男' THEN '爷们'
        WHEN sex = '女' THEN '姑娘'
        ELSE '未知' -- 可选，用于处理sex字段不是'男'或'女'的情况
    END AS title
FROM 
    student;