MySQL存储过程--case的使用

DDL

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createDate` date NOT NULL,
  `userName` varchar(50) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` enum('男','女') DEFAULT NULL,
  `introduce` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

DML

INSERT INTO student (createDate, userName, phone, age, sex, introduce) VALUES
('2023-10-23', '张三', '13800138000', 20, '男', '我是张三，喜欢读书。'),
('2023-10-22', '李四', '13900139000', 21, '女', '我是李四，喜欢运动。'),
('2023-10-21', '王五', '13700137000', 22, '男', '我是王五，喜欢音乐。'),
('2023-10-20', '赵六', '13600136000', 20, '女', '我是赵六，喜欢画画。'),
('2023-10-19', '孙七', '13500135000', 21, '男', '我是孙七，喜欢旅行。'),
('2023-10-18', '周八', '13400134000', 22, '女', '我是周八，喜欢摄影。'),
('2023-10-17', '吴九', '13300133000', 20, '男', '我是吴九，喜欢编程。');

DQL

SELECT 
    id,
    createDate,
    userName,
    phone,
    age,
    sex,
    introduce,
    CASE 
        WHEN sex = '男' THEN '爷们'
        WHEN sex = '女' THEN '姑娘'
        ELSE '未知' -- 可选，用于处理除'男'和'女'之外的其他情况
    END AS gender_description
FROM 
    student;