//mysql中 创建存储过程脚本, loop_times (入参)
DROP PROCEDURE IF EXISTS proc_api ;
CREATE PROCEDURE proc_api (IN loop_times INT)
BEGIN
DECLARE var INT DEFAULT 0;
WHILE var < loop_times DO
SET var = var + 1 ;
INSERT INTO api_test (
`id`,
`name`,
`create_time`
)VALUES(
var,
'192.168.30.567',
DATE(NOW())
) ;
END
WHILE ;
END
//调用存储过程,1000000为loop_times (入参)
CALL proc_api (1000000);