mysql怎么样创建存储过程_mysql如何创建存储过程？

2011-06-10 回答

/*先建表stugra*/

create table `stugra` (

`name` char(20) default null,

`mark` int(3) default null

) engine=innodb default charset=gbk

insert into stugra values ('aa','59');

insert into stugra values ('fa','11');

insert into stugra values ('aga','99');

insert into stugra values ('v','32');

insert into stugra values ('da','77');

insert into stugra values ('gf','44');

insert into stugra values ('sadf','0');

insert into stugra values ('eef','32');

insert into stugra values ('ggg','60');

存储过程：

delimiter $$

drop procedure if exists `pro_find`$$

create definer=`root`@`localhost` procedure `pro_find`()

begin

declare done int default 0;

declare a,b int default 0;

declare cur1 cursor for select mark from stugra;

declare continue handler for sqlstate '02000' set done = 1;

open cur1;

repeat

fetch cur1 into a;

if not done then

if a<60 then

set b=b+1;

end if;

else

select b;

end if;

until done end repeat;

close cur1;

end$$

delimiter ;

没使用count ，使用了循环和选择，还使用了游标，没说不能使用游标吧！