Mysql存储过程批量添加账号

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();

创建成功：