DDL
CREATE TABLE student (
id INT PRIMARY KEY AUTO_INCREMENT,
createDate DATE NOT NULL,
userName VARCHAR(255) NOT NULL,
phone VARCHAR(15),
age INT,
sex ENUM('M', 'F', 'O') NOT NULL, -- 假设'M'代表男,'F'代表女,'O'代表其他
introduce TEXT
);
SQL
SELECT
id,
userName,
CASE
WHEN sex = 'M' THEN '男性'
WHEN sex = 'F' THEN '女性'
WHEN sex = 'O' THEN '泰国人'
ELSE '未知' -- 这个ELSE分支是可选的,为了处理异常情况,如果确定sex只有M、F、O则可以省略
END AS displaySex
FROM
student
LIMIT
9527;