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 vector reduces the vector to a single value using a callback functionphp ldap 函数 set a callback function to do re binds on referral chasingphp pdf 函数 get name of unsuccessfull api functionphp statistic 函数 probability density function of the exponential distributionphp swoole 函数 check if a timer callback function is existedphp uopz 函数 provide a return value for an existing functionphp imagick applies a function on the imagephp reflectionfunction returns a dynamically created closure for the functionphp sqlite3 registers a php function for use as an sql collating functionphp swoole mysql register callback function based on event name.
关注编程学问公众号