View a mysql procedure in command line

mysql> show create procedure spg.sp_test;
+-----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Procedure | sql_mode | Create 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
|+-----------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email