摘要:
select *,case t.name when 1 then '男' when 2 then '女' end as sex from tt t结果:一. 控制流程函数1.CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END该语句用于在不同情况 阅读全文