**創建**
```
create procedure test1(in name int)
begin
declare username varchar(20);
case name
when 1 then
set username=1;
when 2 then
set username=2;
else
set username='未設置名稱';
end case;
update a set name = username;
end
$$;
```
**查詢操作使用case**
```
select (case sex when 1 then '男' else '女' end) as'性別' from a;
```
