传统存储过程的写法

一个传统存储过程的写法

delimiter // 
CREATE PROCEDURE adddevice (logCount BIGINT)
BEGIN

SET @currentCount = 0 ;
WHILE @currentCount < logCount DO
	INSERT INTO `n4a`.`n4a_asset_pt` (
	`id`,
	`sortId`,
	`cid`,
	`mac`,
	`authType`,
	`deviceType`,
	`manuFacturer`,
	`model`,
	`deptId`,
	`user`,
	`phone`,
	`mail`,
	`reMarks`,
	`regreView`,
	`secadminRemarks`,
	`regreViewTime`,
	`authterTable`,
	`operaStatus`,
	`updateStatus`
)
VALUES
	(
		UUID_SHORT(),
		@currentCount +3,
		UUID_SHORT(),
		UUID_SHORT(),
		'4',
		'1',
		'lm',
		'acer',
		'1004',
		'',
		'',
		'',
		'',
		'3',
		NULL,
		'2020-12-29 11:31:43',
		NULL,
		'0',
		'0'
	);
SET @currentCount = @currentCount + 1 ;
END
WHILE ;
END ;// 
delimiter ;


CALL adddevice (20000);

DROP PROCEDURE
IF EXISTS adddevice;

有需要的同学可以借鉴该模板