1.创建储存过程
use mysql_test;
drop procedure if exsits sp_update_sex;
delimiter $$
create procedure sp_update_sex(in cid int,in sex char(1))
begin
update customers set cust_sex = csex where cust_id = cid;
end $$
2.储存函数
use mysql_test;
delimiter $$
create function f_upsex(fid int)
returns char(1)
deterministic
begin
declare sex char(1);
select cust_sex into sex from customers where fid=cust.id;
if sex is null then
return(select'没有该用户');
else if sex ='F' then
return (select'女');
else
return(select'男')
end if;
end $$
3.光标
声明----declare cur_employee cursor for select age,name from employee;
打开----open cursor_name;
使用----fetch cur_name into varname;
关闭----close cursor_name;
