1.用case when
2.利用mysql的if函数
SELECT
if(stuSex=0,'女','男'),total
FROM
( SELECT count( * ) as total, stuSex FROM student GROUP BY stuSex ) AS A
1.用case when
2.利用mysql的if函数
SELECT
if(stuSex=0,'女','男'),total
FROM
( SELECT count( * ) as total, stuSex FROM student GROUP BY stuSex ) AS A