mysql的存储过程中 计算_mysql计算的存储过程

BEGIN    DECLARE  count1 INT;     DECLARE  min FLOAT;     DECLARE  b INT;     DECLARE  max FLOAT;     DECLARE  cname VARCHAR(500);    DECLARE  kcode VARCHAR(500);  DECLARE qj1  VARCHAR(500); DECLARE qj2  VARCHAR(500); DECLARE qj3  VARCHAR(500); DECLARE qj4  VARCHAR(500); DECLARE qj5  VARCHAR(500);   DECLARE temp1  FLOAT; /**/ DECLARE deft FLOAT;   DECLARE zz1  INT;   DECLARE zz2  INT;   DECLARE zz3  INT;   DECLARE zz4  INT;   DECLARE zz5  INT;   DECLARE vResult TINYINT;   DECLARE allweek CURSOR FOR select count(t.code) as count1, min(t.weekMin) as minweek, max(t.weeKmax) as maxweek,t.code as code1,t.name as cname from Week t where t.weekMin>0 and t.weekMax>0 group by t.code ;    declare continue handler for not found set b=1;  delete from weekrestbackups where content = null or content = ''; insert into weekrestbackups  select * from weekreset;     delete from weekreset  where 1=1; open allweek; repeat  begin FETCH allweek INTO count1, min, max, kcode,cname;  /*select count1, min,max,kcode;*/ set temp1 = (max-min)/5; select count(*) into zz1  from Week t where t.weekMin > min  and t.weekMin < (min+temp1) and t.code = kcode;       set qj1 =CONCAT(min,'--',FORMAT((min+temp1),2),'(',zz1,'周)',FORMAT(zz1/count1*100,2),'%'); select count(*) into zz2  from Week t where t.weekMin >= (min+(temp1*1))  and t.weekMin < (min+temp1*2) and t.code = kcode;  set qj2 =CONCAT(FORMAT(min+(temp1*1),2),'--',FORMAT((min+temp1*2),2),'(',zz2,'周)',FORMAT(zz2/count1*100,2),'%'); select count(*) into zz3  from Week t where t.weekMin >= (min+(temp1*2))  and t.weekMin < (min+temp1*3) and t.code = kcode;  set qj3 =CONCAT(FORMAT(min+(temp1*2),2),'--',FORMAT((min+temp1*3),2),'(',zz3,'周)',FORMAT(zz3/count1*100,2),'%'); select count(*) into zz4  from Week t where t.weekMin >= (min+(temp1*3))  and t.weekMin < (min+temp1*4) and t.code = kcode;  set qj4 =CONCAT(FORMAT(min+(temp1*3),2),'--',FORMAT((min+temp1*4),2),'(',zz4,'周)',FORMAT(zz4/count1*100,2),'%'); select count(*) into zz5  from Week t where t.weekMin >= (min+(temp1*4))  and t.weekMin <= (max) and t.code = kcode;  set qj5 =CONCAT(FORMAT(min+(temp1*4),2),'--',max,'(',zz5,'周)',FORMAT(zz5/count1*100,2),'%'); /*select qj1,qj2,qj3,qj4,qj5,kcode,min,max,count1; */ set deft=0.00; insert into weekreset(table_id,createTime,showTime,code,count,max,min,name,qj1,qj2,qj3,qj4,qj5) values(UUID(),UNIX_TIMESTAMP(),SYSDATE(),kcode,count1,max,min,cname,qj1,qj2,qj3,qj4,qj5); end; until b=1 end repeat; close allweek; END