I'have a problem with my function:
Code: Select all
CREATE FUNCTION MovePhoto(oldFile VARCHAR(255), newFile VARCHAR(255), cmp CHAR(36))
RETURNS INT
BEGIN
DECLARE c INT;
SELECT COUNT(*) INTO c FROM photo WHERE name = @newFile;
RETURN c;
END//
Anybody knows where is the problem?
Thanks!