mysql循环插入数据存储过程

CREATE TABLE `hack_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `boke` varchar(255) DEFAULT NULL COMMENT '博客',
  `phone` varchar(22) DEFAULT NULL COMMENT '手机',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

BEGIN
    DECLARE i int default 1;
    WHILE(i < 200000) DO
            insert into hack_user(boke, phone) value ('https://my.oschina.net/JavaXiaofeng', '12312312312');
            SET i = i+1;
    END WHILE;
END;