DROP PROCEDURE dowhile;

DELIMITER //   
create PROCEDURE dowhile()
BEGIN
    DECLARE i int DEFAULT 1;
    DECLARE j int DEFAULT 1;
    START TRANSACTION;
          WHILE i<7 DO
          		WHILE j<4 DO
          			INSERT INTO SCORE VALUES(NULL,i,j,FLOOR(RAND()*100));
                	set j=j+1;
                END WHILE;
        	set i=i+1;
          END WHILE;
    COMMIT;
END

//
DELIMITER ;