mysql> SHOW CREATE PROCEDURE get_season_dates;
+------------------+----------+------------------+
| Procedure        | sql_mode | Create Procedure |
+------------------+----------+------------------+
| get_season_dates |          | NULL             | 
+------------------+----------+------------------+
1 row in set (0.00 sec)

mysql> \G
ERROR: 
No query specified

mysql> SHOW CREATE PROCEDURE get_season_dates\G
*************************** 1. row ***************************
       Procedure: get_season_dates
        sql_mode: 
Create Procedure: NULL
1 row in set (0.00 sec)