mysql存储过程游标的使用
mysql存储过程游标的使用
begin
DECLARE cur1 CURSOR for select userid,susername from user_student;
DECLARE done INT DEFAULT 0; #repeat结束标识
DECLARE uname varchar(40);
DECLARE uid varchar(20);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; #表示当循环列表完毕后将don
原创
2021-06-10 14:35:52 ·
81 阅读 ·
0 评论