Excellent set of tutorials covering stored procedures in MySQL with specific chapters on Parameters, Variables, Conditional statements, Loops and more.
browse: mysql, stored procedure, tutorials