MySQL语法复习--储存过程与储存函数_fetch cur into varname;-优快云博客

本文链接：https://blog.youkuaiyun.com/Alis_xt/article/details/52891615

本文介绍了MySQL中存储过程和函数的创建与使用方法，包括更新客户性别信息的存储过程及查询用户性别的存储函数，并涉及了光标的声明与操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >



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;