1,新建函数。在数据库的函数里面新建过程
2,输入函数的参数个数、参数名、参数类型等
3,编写函数。
4,结果
5,完整代码 以及注释
BEGIN
/*定义变量*/
DECLARE v_id INT;
DECLARE v_titile VARCHAR(200);
/*用户控制循环是否结束*/
DECLARE done_id INT;
/*定义游标*/
DECLARE cursor_item CURSOR FOR SELECT id,titile FROM app01_classes;
/*当游标到达尾部的时候,mysql自动设置为done=1*/
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done_id = 1;
/*打开游标*/
OPEN cursor_item;
/*循环开始*/
cursor_loop_shop :LOOP
/*移动游标并赋值*/
FETCH cursor_item INTO v_id,v_titile;
/*游标到达尾部,退出循环*/
IF done_id = 1 THEN
LEAVE cursor_loop_shop;
END IF;
/*循环输出信息 do something*/
/*查找信息*/
SELECT v_id,v_titile;
/*插入信息*/
INSERT INTO app01_student (age,username,gender,classes_id)VALUES(v_id,v_titile,6,6);
/*循环结束*/
END LOOP cursor_loop_shop;
/*关闭游标*/
CLOSE cursor_item;
END