MYSQL分享：获取存取过程完整定义语句_MySQL

MYSQL分享：获取存取过程完整定义语句

[sql]

SELECT db,specific_name AS OBJECT_NAME ,

CONCAT(

CHAR(13),

CHAR(10),

'DELIMITER $$',

CHAR(13),

CHAR(10),

CHAR(13),

CHAR(10),

'USE `',

db,

'`$$',

CHAR(13),

CHAR(10),

CHAR(13),

CHAR(10),

'DROP PROCEDURE IF EXISTS `',

specific_name,

'`$$',

CHAR(13),

CHAR(10),

CHAR(13),

CHAR(10),

'CREATE ',

security_type,

'=`',

REPLACE(`definer`, '@', '`@`'),

'` PROCEDURE `',

specific_name,

'` (',

param_list,

')',

CHAR(13),

CHAR(10),

body,

'$$',

CHAR(13),

CHAR(10),

CHAR(13),

CHAR(10),

'DELIMITER ;',

CHAR(13),

CHAR(10),

CHAR(13),

CHAR(10)

) AS DEFINITION

FROM

mysql.proc a

WHERE `type` = 'PROCEDURE'