1、批量插入

DROP PROCEDURE IF EXISTS `insertManyDate`;  
DELIMITER ;; 
CREATE   PROCEDURE `insertManyDate`(IN `beginDate` DATE,IN `endDate` DATE)  #DEFINER =
    #COMMENT '根据输入的起止日期，循环插入每天的时间'  
BEGIN  
  
DECLARE nowdate DATE DEFAULT NOW();  
DECLARE endtmp DATE DEFAULT NOW();  
SET nowdate = DATE_FORMAT(beginDate,'%Y%m%d');  
SET endtmp = DATE_FORMAT(endDate,'%Y%m%d');  
WHILE nowdate<endtmp   
DO  
INSERT INTO db_month.`student`(id,create_time) VALUES(NULL,nowdate);  
SET nowdate = DATE_ADD(nowdate,INTERVAL 1 DAY);  
END WHILE;  
COMMIT;   
END;;


CALL insertManyDate(20160601,20160801);