Mysql创建存储过程DROP PROCEDURE dowhileDELIMITER //create PROCEDURE dowhile()BEGINDECLARE i int DE
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 ;