Quick tut on how to create a stored procedure in mysql and call it as a normal sql query using sql yog.

source