MySQL语法复习--储存过程与储存函数

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;​

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;​