mysql调用存储过程实现批量插入数据

CREATE PROCEDURE tb_option () 
BEGIN

DECLARE i BIGINT DEFAULT 1;

WHILE i < 50000001 DO

    INSERT INTO `数据库名`.`表名` (`字段`) VALUES (i);

SET i = i + 1;


END
WHILE;

COMMIT;

#提交
END;

CALL tb_option ();