stored procedure to create a bunch of ratings

gistfile1.txt

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `new_procedure`()
BEGIN
DECLARE counter int;
set counter = 0;

while counter < 1000000 do
	insert into Rating (Rating, MovieID) VALUES (truncate(rand()*10, 0), 1);
    set counter=counter+1;
end while;
-- Runs in 418 seconds
END$$
DELIMITER ;