Mysql参考手册

20.2.5. SHOW PROCEDURE STATUS和SHOW FUNCTION STATUS 

SHOW {PROCEDURE | FUNCTION} STATUS [LIKE 'pattern']

这个语句是一个MySQL的扩展。它返回子程序的特征，如数据库，名字，类型，创建者及创建和修改日期。如果没有指定样式，根据你使用的语句，所有 存储程序和所有存储函数的信息都被列出。 

mysql> SHOW FUNCTION STATUS LIKE 'hello'\G
  
    
*************************** 1. row ***************************
  
    
           Db: test
  
    
         Name: hello
  
    
         Type: FUNCTION
  
    
      Definer: testuser@localhost
  
    
     Modified: 2004-08-03 15:29:37
  
    
      Created: 2004-08-03 15:29:37
  
    
Security_type: DEFINER
  
    
      Comment:

你可以从INFORMATION_SCHEMA中的ROUTINES表获得有关存储子程序的信息。请参阅23.1.14节，“INFORMATION_SCHEMA ROUTINES 表”。

相关文章
mysql解决错误the total number of locks exceeds the lock table sizemysql alter procedure和alter functionmysql show语句mysql create function/drop function语法mysql create procedure和create functionmysql drop procedure和drop functionmysql show语句的扩展mysql show create procedure和show create functionmysql show create view语法mysql show procedure status和show function statusmysql show语法php newt 函数 set a callback function which gets invoked when user presses the suspend keyphp runkit 函数 change a function s namephp statistic 函数 probability mass function of the poisson distributionphp uopz 函数 creates a function at runtimephp gearmanjob get function namephp sqlite pdo registers a user defined function for use as a collating function in sql statementsphp soapclient calls a soap function deprecated php swoole mysql register callback function based on event name.php swoole server shutdown the master server process this function can be called in worker processes.
关注编程学问公众号