SP Parameter

gistfile1.sql

DELIMITER $$
CREATE PROCEDURE CountOrderByStatus(
        IN orderStatus VARCHAR(25),
        OUT total INT)
BEGIN
        SELECT count(orderNumber)
        INTO total
        FROM orders
        WHERE status = orderStatus;
END;

CALL CountOrderByStatus('in process',@total);
SELECT @total AS total_in_process;