游标 mysql mysql>mysql>mysql> delimiter $$mysql> create procedure myproc (in_customer_id int) -> begin -> -> declare l_first_name varchar(30); -> declare l_id int; -> declare l_city varchar(30); -> declare l_department_count int; -> declare no_more_departments int; -> -> declare dept_csr cursor for -> select id,first_name, city -> from employee; -> -> declare continue handler for not found set no_more_departments=1; -> -> set no_more_departments=0; -> open dept_csr; -> dept_loop:repeat -> fetch dept_csr into l_id,l_first_name,l_city; -> if no_more_departments=0 then -> set l_department_count=l_department_count+1; -> end if; -> select l_id,l_first_name,l_city; -> until no_more_departments -> end repeat dept_loop; -> close dept_csr; -> set no_more_departments=0; -> -> -> end$$query ok, 0 rows affected (0.00 sec)