Stored Procedure Example

This procedure just for assignment an "a" value to "b":

mysql> create procedure boo( in a int, out b int)
        > begin
        > select a into b;
        > end;
        > //

mysql> call boo(12, @c)//
mysql> select @c//