MySQL批量插入数据

DROP PROCEDURE IF EXISTS proc_initData_one;
DELIMITER $
CREATE PROCEDURE proc_initData_one()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i<=500 DO
        INSERT INTO employee(LastName,DepartmentID) VALUE(CONCAT("路人",i,"号"),i);
        SET i = i+1;
    END WHILE;
END $

CALL proc_initData_one;