BEGIN DECLARE i int DEFAULT 1; DECLARE j int DEFAULT 1; WHILE i<15 DO WHILE j<5 DO INSERT *** VALUES(NULL,'***',i,j,0); SET j=j+1; IF (i=14 AND j=3) THEN SET j=5; END IF; END WHILE; SET j=1; SET i=i+1; END WHILE; END
BEGIN DECLARE i int DEFAULT 1; DECLARE j int DEFAULT 1; WHILE i<15 DO WHILE j<5 DO INSERT *** VALUES(NULL,'***',i,j,0); SET j=j+1; IF (i=14 AND j=3) THEN SET j=5; END IF; END WHILE; SET j=1; SET i=i+1; END WHILE; END