MySQL 存储过程中游标的循环输出

2009-04-17 04:41:54 519 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

xiaoyang344430256 墨衍会员 · AI 创作全网分发关注 + 加入社区

MySQL表名大小写敏感问题终极解决：lower_case_table_names=1不生效的3个隐藏坑本文深入剖析了MySQL表名大小写敏感问题中，设置lower_case_table_names=1参数不生效的三个核心原因。关键在于理解该参数只能在数据库初始化前设置，并需排查配置文件优先级与正确停止服务的顺序。文章提供了从Windows迁移到Linux的完整避坑指南与验证方法，帮助DBA和开发者彻底解决这一跨平台兼容性难题。阅读详情

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 ;