Mega Code Archive

 
Categories / MySQL / Command Mysql
 

Check information for stored procedures by the table information_schema routines

mysql> mysql> SELECT routine_name, routine_type, created     -> FROM information_schema.routines     -> WHERE routine_schema='mylibrary'; Empty set (0.00 sec) mysql>