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 ;