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'
bitsCN.com
上一篇: PHP动态图像的创建_php基础
下一篇: 关于优化步骤的详细介绍