SELECT au_lname, au_fname, city,
CASE state ----state列名
WHEN 'CA' THEN '勇士队' ---符合条件则转换为对应信息
WHEN 'TN' THEN '篮网队'
WHEN 'OR' THEN '魔术队'
WHEN 'MI' THEN '雄鹿队'
WHEN 'IN' THEN '步行者'
ELSE '不知道'
END as 'NBA' ---将state列名改为别名NBA
FROM authors
case...when...then...end 批量修改列记录
最新推荐文章于 2022-09-22 17:05:25 发布