Mysql创办存储过程

Mysql创建存储过程

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 ;