/*-----------------------------------------------------------------------------
  Display code for all procedures, functions and triggers
-----------------------------------------------------------------------------*/
SELECT routine_name, routine_type, routine_definition, created, last_altered
  from information_schema.routines
 order by 2,1
 
/
/*-----------------------------------------------------------------------------
  Display code for an individual procedure or function
-----------------------------------------------------------------------------*/
SHOW create procedure [name]