MySQL标准存储过程示例

 存储过程示例

---保证没有同名的存储过程
DROP PROCEDURE IF EXISTS `batchInsert`;

delimiter;;
CREATE DEFINER = `root` @`%` PROCEDURE `batchInsert` ( )

BEGIN
DECLARE
		id BIGINT ( 20 );
DECLARE
		identifier VARCHAR ( 64 );
DECLARE
		account BIGINT ( 20 );
DECLARE
		login_name VARCHAR ( 30 );
	
SET id = 121;
	
SET account = 296986;
	WHILE
			id <= 230 DO
			
			SET login_name = CONCAT( '', account );
		INSERT INTO `t_employee` ( `id`, `login_name`, `login_pwd`, `actual_name`, `phone`, `email`, `department`, `is_disabled`, `remark`, `create_user`, `update_time`, `create_time` )
		VALUES
			(
				id,
				login_name,
				NULL,
				login_name,
				'',
				'',
				'阿里达摩研究院',
				'0',
				NULL,
				'0',
				NOW( ),
				NOW( ) 
			);
		
		SET id = id + 1;
		
		SET account = account - 1;
		
	END WHILE;
	
	END;;

delimiter;

---删除存储过程
DROP PROCEDURE IF EXISTS `batchInsert`;