College of San Mateo: Bob Timlin's "Prepared Statements and Store Procedures and Functions"
Read this chapter, which will provide and appropriate overview of using Stored Procedures and Functions in MySQL Server.
Click http://web.archive.org/web/20150723234354/http://www.timlin.net/csm/cis363/CIS363_Ch17-18.pdf link to open resource.