while实现:
DELIMITER //
CREATE PROCEDURE callback0001()
BEGIN
DECLARE num INT;
DECLARE id INT;
SET num = 9001;
SET id = 90001;
WHILE
num < 9102 DO
INSERT INTO user(ID,ACCOUNT,PASSWORD, NAME,TYPE)
VALUES(ID,num,111111,CONCAT(“admin”, num),‘1’);
SET num = num + 1;
SET id = id + 1;
END WHILE;
END;
//
CALL callback0001();
创建成功: