SELECT CONCAT('PR_', p.db,'.',p.name ) FileName ,
CONCAT(
'
DELIMI','TER $$
USE `',p.db,'`$$
DROP PROCEDURE IF EXISTS `',p.name, '`$$
CREATE DEFINER=','`',
LEFT(DEFINER, -1+LOCATE('@',DEFINER)),
'`@`',
RIGHT(DEFINER,LENGTH(DEFINER)-LOCATE('@',DEFINER)),
'`'
,' PROCEDURE `',p.name ,'`(',p.param_list,')
',p.body_utf8,
'$$
DELIMI','TER ;
' ) AS sql_create
FROM mysql.proc AS p
WHERE p.db LIKE '%'
AND TYPE LIKE 'PROC%'
ORDER BY p.db,p.name ;
mysql 生成完整的存储过程定义语句
最新推荐文章于 2022-06-29 10:49:45 发布