mysql create procedure

DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $$
CREATE PROCEDURE proc_initData()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i<=1000000 DO
        INSERT INTO TB_100000 VALUE(i,NOW());
        set i = i + 1;
    END WHILE;
    ALTER TABLE tb_100000 DISABLE KEYS;
  SET UNIQUE_CHECKS=0;
  SET AUTOCOMMIT=0;

  alter table tb_100000 enable keys;
  SET UNIQUE_CHECKS=1;
    SET AUTOCOMMIT=1;
END; $$
DELIMITER ;
CALL proc_initData();