【MySql】mysql生成完整的存储过程定义语句

MEI

1. SELECT   CONCAT('PR_', p.db,'.',p.name ) FileName ,
   
2. CONCAT(
   
3. '
   
4. DELIMI','TER $
   
5. 
   
6. USE `',p.db,'`$
   
7. 
   
8. DROP PROCEDURE IF EXISTS `',p.name, '`$
   
9. 
   
10. CREATE DEFINER=','`',
    
11. LEFT(DEFINER, -1+LOCATE('@',DEFINER)),
    
12. '`@`',
    
13. RIGHT(DEFINER,LENGTH(DEFINER)-LOCATE('@',DEFINER)),
    
14. '`'
    
15. ,' PROCEDURE `',p.name ,'`(',p.param_list,')
    
16. ',p.body_utf8,
    
17. '$
    
18. 
    
19. DELIMI','TER ;
    
20. ' ) AS sql_create
    
21. FROM mysql.proc AS p
    
22. WHERE p.db LIKE '%'
    
23. AND TYPE LIKE 'PROC%'
    
24. ORDER BY p.db,p.name ;

复制代码