使用Navicat Premium向mysql插入2000000条数据

DELIMITER //

DROP PROCEDURE IF EXISTS sys_log;

 CREATE PROCEDURE sys_log()

    BEGIN

    DECLARE n int DEFAULT 1;

        WHILE(n<2000000) DO

INSERT INTO `sys_log` VALUES (n, '超级系统管理员', '查询实时工况数据', '/keyParameterMonitoring/getNewestUnitData', '{\"role\":[\"KEY_SUPER_ADMIN\"],\"username\":[\"超级系统管理员\"],\"nuclearCode\":[\"XX_XXX\"],\"machineSetCode\":[\"11111#\"],\"realData\":[\"False\"],\"flag\":[\"1\"]}', '127.0.0.1, '2024-05-30 17:14:12', 'KEY');

        set n = n + 1;

        END WHILE;

   END //

DELIMITER ;

call sys_log();