create PROCEDURE makefields (param1 int, param2 int)
BEGIN
  DECLARE x int default 1;
  DECLARE y int default 1;
  DECLARE st int default 0;
WHILE y <= 15 DO
  WHILE x <= 15 DO
     SET st = RAND()*10 / (10 + 1) * ((param2 - param1) + param1)+0.5;
     insert into fields (xcoord,ycoord,fid_type) values (x,y,st);
     SET x = x+1;
  END WHILE;
  SET x = 1;
  SET y = y+1;
END WHILE;
END;

create PROCEDURE makefields (param1 int, param2 int)
BEGIN
  DECLARE x int default 1;
/* Ошибка SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 */
/* Affected rows: 0  Найденные строки: 0  Предупреждения: 0  Длительность  0 of 11 queries: 0,000 sec. */