作者:鬼鬼太子_157 | 来源:互联网 | 2018-04-26 01:04
delimiter$$BEGINDECLAREitivarchar(25);declaremajvarchar(25);declareclatinyint(1);declarebuffertinyint(1);declaregrdenum('2014级','2012级','2013级');declaremycurCURSORforselectinstitude,major,grade,classfro
mysqlcursor存储
delimiter $$
BEGIN
DECLARE iti varchar(25);
declare maj varchar(25);
declare cla tinyint(1);
declare buffer tinyint(1);
declare grd enum('2014级','2012级','2013级');
declare mycur CURSOR for select institude,major,grade,class from show_information;
open mycur;
fetch mycur into iti,maj,grd,cla;
while(iti is not null)DO
select buffer=count(*) from show_information where institude=iti and major=maj and grade=grd and class=cla;
update statistics set classnum=buffer where institude=iti and major=maj and grade=grd and class=cla;
fetch mycur into iti,maj,grd,cla;
end while;
close mycur;
END
$$
delimiter ;