MySQL 5.1 Reference Manual: "Stored Procedures and the Grant Table"
Read sections 18.1 and 18.2 for an overview of stored procedures and stored procedure syntax in RDMS. As you read please keep in mind the effects that stored procedures are likely to have on the Database System.
Click https://web.archive.org/web/20170401034705/http://www.cs.duke.edu/csl/docs/mysql-refman/stored-procedures.html link to open resource.