mysql游标嵌套游标_mysql游标嵌套循环

最近在mysql开发过程中用到了游标的嵌套循环,下面列举了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(c