delimiter //
create procedure addresult()
BEGIN
DECLARE empno char(6) ; ename char(8) ; sex char(6) ;birthday date ; dangyuan char(6) ;workdate date;salary2 float(10,2); maxsal float(10,2); dname char(20); cid char(40); done int;
--这部分声明太多，超过字数上限了
DECLARE cur CURSOR for
select worker.职工号,worker.姓名,worker.性别,worker.出生日期,worker.党员否,worker.参加工作时间,department.部门名称,salary.工资 as  cid from worker,department,salary where worker.职工号=salary.职工号 and department.部门号=worker.部门号 and salary.工资=maxsal;
DECLARE CONTINUE HANDLER for not FOUND set done=1;
SELECT max(工资) into maxsal FROM salary;
open cur;
posLoop:LOOP
FETCH next from cur INTO empno,ename,sex,birthday,dangyuan,workdate,salary2,dname ;
 IF done=1 THEN
  LEAVE posLoop;
END IF;
insert into imformation(职工号,姓名,性别,出生日期,党员否,参加工作时间,工资,部门名称) value(empno,ename,sex,birthday,dangyuan,workdate,salary2,dname);
select empno,ename,sex,birthday,dangyuan,workdate,salary2,dname from imformation;
END LOOP posLoop;
CLOSE cur;
end;
//