0613游标及其应用 MySQL 【例69】创建一个存储过程,计算xs表中行的数目。 del imiter $$ create procedure compute out number integer) egIn declare xh char(6) declare found boo lean defau ltt number xs:游标名 declare number xs-cursor fo select学号 from xs; declare cont inue handler for not found set found=false set number =0 open number xs fetch number xs into xh: whi le found do set number=number +1 fetch number xs into xh end while close number xs: ends de l imiter cal I compute (enum); select @num; MySQL数据库应用》ht: mysql xg. hactcm edu.cn 第10页《MySQL数据库应用》 http://mysql.xg.hactcm.edu.cn/ 第 10 页 6.1.3游标及其应用 【例6.9】创建一个存储过程，计算xs表中行的数目。 delimiter $$ create procedure compute(out number integer) begin declare xh char(6); declare found boolean default true; declare number_xs cursor for select 学号 from xs; declare continue handler for not found set found=false; set number=0; open number_xs; fetch number_xs into xh; while found do set number=number+1; fetch number_xs into xh; end while; close number_xs; end$$ delimiter ; call compute(@num); select @num; number_xs ：游标名