5,889
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP PROCEDURE IF EXISTS `getData` $$
CREATE PROCEDURE `getData`(out a1 char(5),out a2 varchar(20),out a3 char(5))
BEGIN
declare done int default 0;
declare num char(5);
declare s_name varchar(20);
declare s_course char(5);
declare stu_data cursor for
select s.student_id,s.name,st.course_id
from student s left join (select student_id,course_id
from clazz
group by student_id
)as st
on s.student_id = st.student_id
order by student_id asc;
declare continue handler for not found set done = 1;
/*-------------open cursor------------*/
open stu_data;
cursor_loop:loop
fetch stu_data into a1,a2,a3;
select a1,a2,a3 into outfile 'c:a.txt';
/*---------loop--------*/
if done=1 then
leave cursor_loop;
end if;
end loop cursor_loop;
close stu_data;
END $$
DELIMITER ;