create function mysql example

CREATE PROCEDURE simpleproc (OUT param1 INTEGER(11))
BEGIN
  DECLARE val INTEGER(11);
  SELECT COUNT(*) INTO val FROM t;
  SET param1 := val; 
END;


CREATE FUNCTION sipleFunc() 
RETURNS INTEGER(11)
BEGIN
  DECLARE val INTEGER(11);
  SELECT COUNT(*) INTO val FROM t;
  RETURN val;
END;

http://www.sql.ru/forum/actualthread.asp...