It says this procedure has invalid syntax. How do I fix this procedure?
I tried it for hours but didn't work and it's frustrating.

CREATE PROCEDURE `gcd` (a INT, b INT) RETURNS INTEGER
BEGIN
DECLARE t INTEGER;
loop_label: WHILE b <> 0 DO
SET t = b;
SET b = MOD(a, b);
SET a = t;
END WHILE;
RETURN a;
END

Thanks!

PROCEDUREs don't return values. FUNCTIONs do.

--
felix