use md5db;
DROP PROCEDURE if exists myFunction;
delimiter $$
CREATE PROCEDURE myFunction()
BEGIN
DECLARE i INT DEFAULT 0;
WHILE (i<1000001) DO
INSERT INTO `md5`(`MD5_TXT`, `MD5_HASH`) VALUES (i,md5(i));
SET i=i+1;
END WHILE;
END$$
delimiter ;
call myFunction();