Mysql参考手册

20.2.4. SHOW CREATE PROCEDURE和SHOW CREATE FUNCTION 

SHOW CREATE {PROCEDURE | FUNCTION} sp_name

这个语句是一个MySQL的扩展。类似于SHOW CREATE TABLE，它返回一个可用来重新创建已命名 子程序的确切字符串。 

mysql> SHOW CREATE FUNCTION test.hello\G
  
    
*************************** 1. row ***************************
  
    
       Function: hello
  
    
       sql_mode:
  
    
Create Function: CREATE FUNCTION `test`.`hello`(s CHAR(20)) RETURNS CHAR(50)
  
    
RETURN CONCAT('Hello, ',s,'!')
相关文章
mysql alter procedure和alter functionmysql show语句mysql create function/drop function语法mysql create index语法mysql create procedure和create functionmysql create table语法mysql create trigger语法mysql create view语法mysql createmysql drop procedure和drop functionmysql show语句的扩展mysql show create procedure和show create functionmysql show create view语法mysql show procedure status和show function statusmysql show语法php 函数处理 函数 create an anonymous lambda style functionphp mysql xdevapi collection create collection indexphp mysql xdevapi session create new schemaphp mysql xdevapi session create savepointphp swoole mysql register callback function based on event name.
关注编程学问公众号