如何在Mysql中通过注释获取存储过程名称?
例如,我需要这样的东西:
SELECT *
FROM stored_procedures
WHERE comment LIKE '%something%''
发布于 2018-05-02 19:08:13
您可以使用以下代码从information_schema
获取存储过程名称:
SELECT routine_schema, -- database/schema wherein the object resides
routine_name, -- the name of the function/procedure
routine_type, -- PROCEDURE indicates a procedure, FUNCTION indicates a function
routine_definition -- code underlying the sp
routine_comment -- some human readable comment on the routine
FROM information_schema.routines
WHERE routine_comment LIKE '%test%';
发布于 2018-05-02 19:10:25
是的,你可以像这样的评论来搜索proc。
SELECT mysql.proc.name
FROM mysql.proc
WHERE mysql.proc.comment LIKE '%abc%';
https://stackoverflow.com/questions/50133058
复制相似问题