第十章练习

最新推荐文章于 2024-10-08 19:59:42 发布

锦书u

最新推荐文章于 2024-10-08 19:59:42 发布

阅读量45

点赞数

文章标签：数据结构数据库 html

本文链接：https://blog.csdn.net/m0_68926489/article/details/130708070

版权

例10.9】创建一个存储过程，计算student表中行的数目。
use stusys;
select * from student;
delimiter //
create procedure P_tablerows(out v_rows int)
   begin
       declare v_sno char(10);
declare found boolean default true;
declare cur_student cursor for select sno from student;
declare continue handler for not found set found = false;
set v_rows=0;
open cur_student;
fetch cur_student into v_sno;
while found do
           set v_rows=v_rows+1;
fetch cur_student into v_sno;
       end while;
close cur_student;
end //
delimiter ;
call P_tablerows(@rows);
select @rows;
#【例10.10】创建向学生表插入一条记录的过程P_insertStudent，并调用该过程。
use stusys;
delimiter //
create procedure P_insertStudent()
   begin
       insert into student
           value('191005','王燕','女','1999-04-17',null,null);
       select * from student
           where sno='191005';
   end //
delimiter ;