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 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 set reduces the set to a single value using a callback functionphp imap 函数 this function returns an array of messages matching the given search criteriaphp parsekit 函数 return information regarding function argument s php statistic 函数 probability density function of the cauchy distributionphp swoole 函数 add callback function to the next event loopphp uopz 函数 restore a previously backed up functionphp gearmanworker unregister a function name with the job serversphp pht thread function threadingphp solrquery allows grouping results based on the unique values of a function query group.func parameter php swoole mysql register callback function based on event name.
关注编程学问公众号