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;