mysql 游标案例

1. 创建一个emp1表，其结构和数据与emp(emp表）表完全一致。用游标完成操作：显示emp1表中工资低于1500的职员信息,并显示如果给他们涨30%工资后的工资。

create table if not exists emp1
select * from emp;
delimiter //
create procedure cursor1()
begin
declare empno int default 1;
declare ename varchar(10);
declare job varchar(9);
declare mgr int;
declare hiredate date;
declare sal1 decimal(7,2);
declare comm decimal(7,2);
declare deptno int;
declare done boolean default true;
declare cur cursor for select * from emp where sal < 1500;
declare continue handler for sqlstate '02000' set done =