mysql 存储过程实例

mysql 存储过程实例

CREATE PROCEDURE insertValueIntoTestTable (IN m INT) BEGIN
	DECLARE n INT DEFAULT 0;
	WHILE n < m DO
	  INSERT INTO `user`.`role` (`name`, `description`) VALUES ('测试', '测试专用');
		SET n = n + 1;
	END WHILE;
END;
CALL insertValueIntoTestTable(10);
DROP PROCEDURE insertValueIntoTestTable;

 

 安装并配置密码：https://www.likecs.com/show-307170520.html