DELIMITER // DROP PROCEDURE IF EXISTS test;
CREATE PROCEDURE test() BEGIN DECLARE i INT ;
SET i = 0;
lp : LOOP # lp为循环体名,可随意 loop为关键字 INSERT INTO test VALUES (i+11, 'test' , '20' ); # 往test表添加数据
SET i = i + 1; # 循环一次,i加一
IF i > 10 THEN # 结束循环的条件: 当i大于10时跳出loop循环 LEAVE lp;
END IF;
END LOOP;
SELECT * FROM test; END // CALL test(); DELIMITER ;
|