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

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'