Create Stored Procedure Mysql Example. It is used to provide input and to collect output values. The mysql version is 5.0.45.

1) your parameters and values in insert statement are different: Sql (structured query language) (sql) the stored procedure getordercountbystatus () has two parameters: The mysql version is 5.0.45.