MySQL Create stored procedure

The difference between stored procedures and functions reference links:

Http://www.cnblogs.com/lengbingshy/archive/2010/02/25/1673476.html

To create a stored procedure:

DROP PROCEDURE Mypro;
CREATE procedure Mypro (SID int,out Scount INT)
BEGIN

SELECT COUNT (*) into Scount from student where id = SID;
END

Execute the stored procedure:

Call Mypro (1,@C);
Select @c;

To create a function:

DROP FUNCTION Myfun;
CREATE FUNCTION myfun (Sid INT)
RETURNS int
BEGIN
DECLARE Scount int;
SELECT COUNT (*) into Scount from student where Id=sid;
RETURN Scount;
END

Execute function:
SELECT myfun (1)

MySQL Create stored procedure