1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
| # 循环结构
# while循环
# LOOP循环
# repeat循环
# 案例:批量插入,根据次数插入到admin表中多条记录 CREATE PROCEDURE while_test(IN num INT) BEGIN DECLARE n INT DEFAULT 1; WHILE n<=num DO INSERT INTO admin(username,`password`) VALUES(CONCAT('Rose_',n),8888); SET n=n+1; END WHILE; END
CALL while_test(50);
# 案例二:批量插入,但是当次数超过20时就停止 DROP PROCEDURE leave_test; CREATE PROCEDURE leave_test(IN num INT) BEGIN DECLARE n INT DEFAULT 1; a:WHILE n<=num DO INSERT INTO admin(username,`password`) VALUES(CONCAT('Leslie_',n),5555); IF n>=20 THEN LEAVE a; END IF; SET n=n+1; END WHILE a; END
CALL leave_test(100);
|