delimiter //create procedure addresult()BEGINDECLARE 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:LOOPFETCH 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;//