Mysql创办存储过程

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 ;
Mysql创办存储过程

相关文章:

你感兴趣的文章:

标签云: