Mysql----游标的嵌套循环

最新推荐文章于 2024-04-28 09:00:10 发布

end

最新推荐文章于 2024-04-28 09:00:10 发布

阅读量1.4k

点赞数 1

分类专栏： mysql

本文链接：https://blog.csdn.net/endlu/article/details/50808772

版权

本文通过创建tb_dic_class和tb_students两个表，并插入数据，演示了在MySQL中使用游标进行嵌套循环的过程，包括loop-while和loop-repeat嵌套的实现，展示了如何遍历班级并获取每个班级的所有学生信息。

摘要由CSDN通过智能技术生成

游标的嵌套循环,下面列举了3种嵌套循环(loop-loop,loop-while,loop-repeat).

程序用到的表和数据

CREATE TABLE tb_dic_class (
class_id int(11) DEFAULT NULL,
class_name varchar(20) DEFAULT NULL,
createtime datetime DEFAULT 'CURRENT_TIMESTAMP',
modifytime datetime DEFAULT 'CURRENT_TIMESTAMP'
)
ENGINE = INNODB
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_general_ci;

CREATE TABLE tb_students (
id int(11) NOT NULL,
student_name varchar(30) DEFAULT NULL,
class_id int(11) DEFAULT NULL,
createtime datetime DEFAULT 'CURRENT_TIMESTAMP',
modifytime datetime DEFAULT 'CURRENT_TIMESTAMP',
PRIMARY KEY (id)
)
ENGINE = INNODB
AVG_ROW_LENGTH = 5461
CHARACTER SET utf8
COLLATE utf8_general_ci;

INSERT INTO tb_dic_class(class_id, class_name, createtime, modifytime) VALUES
(1, '一班', now(), now());
INSERT INTO tb_dic_class(class_id, class_name, createtime, modifytime) VALUES
(2, '二班', now(), now());
INSERT INTO tb_dic_class(class_id, class_name, createtime, modifytime) VALUES
(3, '三班', now(), now());

SET NAMES 'utf8';
INSERT INTO tb_students(id, student_name, class_id, createtime, modifytime) VALUES
(10, '张三', 1, now(), now());
INSERT INTO tb_students(id, student_name, class_id, createtime, modifytime) VALUES
(20, '李四', 1, now(), now());
INSERT INTO tb_students(id, student_name, class_id, createtime, modifytime) VALUES
(30, '王五', 3, now(), now());