mysql批量插入

DELIMITER $$
CREATE  PROCEDURE InsertValueWithWhile()
BEGIN
   declare _End int default 0;
   while (_End < 100) do
       INSERT INTO emp(empName) VALUES( _End );
       set _End = _End +1;
   end while;
END $$
DELIMITER ; 

call InsertValueWithWhile();