
Untitled
By: a guest on
May 2nd, 2012 | syntax:
PL/SQL | size: 0.40 KB | hits: 45 | expires: Never
CREATE DEFINER = 'root'@'localhost' FUNCTION `test`(
param1 TINYINT
)
RETURNS tinyint(4)
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE iTags TINYINT DEFAULT 0;
SELECT COUNT(*) INTO iTags FROM `socrbase`;
IF param1 < 3 THEN
SET param1 = param1 + 1;
SET iTags = test(param1);
END IF;
RETURN iTags;
END;