Create, Call Procedure in MySql

Create, Call Procedure in MySql

mysql> delimiter //
mysql> CREATE PROCEDURE spg.sp_test(
-> OUT str_id CHAR( 20 ) ,
-> match_name CHAR( 20 )
-> )
-> BEGIN
-> SELECT cc_code INTO str_id
-> FROM spg.tbl_card_types
-> WHERE cc_name = match_name;
-> END//
Query OK, 0 rows affected (0.00 sec)

mysql> delimter ;

mysql> call sp_test(@aa,'VISA');
Query OK, 0 rows affected (0.00 sec)

mysql> select @aa;
+------+
| @aa |
+------+
| VISA |
+------+
1 row in set (0.00 sec)

To Create in phpMyAdmin

DROP PROCEDURE `sp_test`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`(
OUT str_id CHAR( 20 ) ,
match_name CHAR( 20 )
)
BEGIN
SELECT cc_code INTO str_id
FROM spg.tbl_card_types
WHERE cc_name = match_name;
END