mysql 循环结构

while循环

CREATE procedure addStudents() # 创建无参存储过程
BEGIN
    DECLARE i INT;  # 申明变量
    SET i = 0;  # 变量赋值
    WHILE i<5 DO # 结束循环的条件: 当i大于5时跳出while循环
        INSERT INTO student(name,sex,age,class_id,status) VALUES(concat('胡勇健','_',i),'男',20+i,1,1);
        SET i = i+1;    # 循环一次,i加1
    END WHILE;  # 结束while循环
END

repeat循环

CREATE procedure addStudents()
BEGIN
    DECLARE i INT;  # 申明变量
    SET i = 0;  # 变量赋值
    REPEAT
        INSERT INTO student(name,sex,age,class_id,status) VALUES(concat('胡勇健','_',i),'男',20+i,1,1);
        SET i = i+1;    # 循环一次,i加1
    UNTIL i > 5 END REPEAT;
END

loop循环

CREATE procedure addStudents()
BEGIN
    DECLARE i INT;  # 申明变量
    SET i = 0;  # 变量赋值
    lp: LOOP
        INSERT INTO student(name,sex,age,class_id,status) VALUES(concat('胡勇健','_',i),'男',20+i,1,1);
        SET i = i+1;    # 循环一次,i加1
        IF i > 5 THEN
            LEAVE lp;
        END IF;
    END LOOP;
END

调用

call addStudents();