use data store in database to do calculation in stored procedure mysql

1mysql> CALL my_proc_OUT(@M)$$
2Query OK, 1 row affected (0.03 sec)
3mysql> CREATE PROCEDURE my_proc_INOUT (INOUT mfgender INT, IN emp_gender CHAR(1))
4-> BEGIN
5-> SELECT COUNT(gender) INTO mfgender FROM user_details WHERE gender = emp_gender;
6-> END$$
7Query OK, 0 rows affected (0.00 sec)
8

1mysql> CALL my_proc_OUT(@M)$$Query OK, 1 row affected (0.03 sec)
2mysql> CREATE PROCEDURE my_proc_INOUT (INOUT mfgender INT, IN emp_gender CHAR(1))
3-> BEGIN
4-> SELECT COUNT(gender) INTO mfgender FROM user_details WHERE gender = emp_gender;
5-> END$$
6Query OK, 0 rows affected (0.00 sec)
7