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();
  

mysql批量插入