一、光标的使用包括光标的声明、OPEN、FETCH和CLOSE四种
- 声明光标: DECLARE cursor_name CURSOR FOR select_statement;
- OPEN光标: OPEN cursor_name;
- FETCH光标:FETCH cursor_name INTO var_name [, var_name] …
- CLOSE光标: CLOSE cursor_name;
示例
初始化脚本
create table emp(
id int(11) not null auto_increment ,
name varchar(50) not null comment '姓名',
age int(11) comment '年龄',
salary int(11) comment '薪水',
primary key(`id`