blocks|key|1153092|text|SHOW+PROCEDURE+STATUS;
SHOW+FUNCTION+STATUS;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1153093|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;
</code></pre>

blocks|key|4651310|text|show+procedure+status|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|4651311|将向您展示存储过程。|unstyled|4651312|show+create+procedure+MY_PROC|4651313|将向您展示过程的定义。和|4651314|help+show|4651315|将向您显示show命令的所有可用选项。|offset|length|style|CODE|4651316|entityMap^0|0|0|0|0|0|5|4|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|M|3|N|5|F|7|Z|8|@$O|10|P|11|Q|R]]|9|@]|A|$]]|$1|S|3|-4|5|F|7|12|8|@]|9|@]|A|$]]]|T|$]]

<pre><code>show procedure status
</code></pre>

will show you the stored procedures.

<pre><code>show create procedure MY_PROC
</code></pre>

will show you the definition of a procedure. And

<pre><code>help show
</code></pre>

will show you all the available options for the <code>show</code> command.

blocks|key|1160209|text|For+view+procedure+in+name+wise|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1160210|select+name+from+mysql.proc+|code-block|syntax|javascript|1160211|下面用于列出所有过程的代码和下面的代码给出了与show+procedure+status相同的结果|1160212|select+*+from+mysql.proc+|1160213|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

For view procedure in name wise

<pre><code>select name from mysql.proc 
</code></pre>

below code used to list all the procedure and below code is give same result as show procedure status

<pre><code>select * from mysql.proc 
</code></pre>

blocks|key|1153153|text|一种更具体的方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1153154|SHOW+PROCEDURE+STATUS+
WHERE+Db+=+DATABASE()+AND+Type+=+'PROCEDURE'|code-block|syntax|javascript|1153155|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

A more specific way:

<pre><code>SHOW PROCEDURE STATUS 
WHERE Db = DATABASE() AND Type = 'PROCEDURE'
</code></pre>

blocks|key|586508|text|如上所述，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|586509|show+procedure+status;|code-block|syntax|javascript|586510|确实会显示一个过程列表，但会显示服务器范围内的所有过程。|586511|如果您只想查看单个数据库中的内容，请尝试执行以下操作：|586512|SHOW+PROCEDURE+STATUS+WHERE+Db+=+'databasename';|586513|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

As mentioned above,

<pre><code>show procedure status;
</code></pre>

Will indeed show a list of procedures, but shows all of them, server-wide.

If you want to see just the ones in a single database, try this:

<pre><code>SHOW PROCEDURE STATUS WHERE Db = 'databasename';
</code></pre>

blocks|key|3807872|text|替代方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3807873|SELECT+*+FROM+INFORMATION_SCHEMA.ROUTINES|code-block|syntax|javascript|3807874|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Alternative:

<pre><code>SELECT * FROM INFORMATION_SCHEMA.ROUTINES
</code></pre>

blocks|key|3808042|text|我更喜欢的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3808043|3808044|列出了函数和过程，|ordered-list-item|3808045|让我知道哪些是函数和过程，|3808046|给出了过程的名称和类型而不是其他，|offset|length|style|BOLD|3808047|根据当前数据库而不是当前数据库筛选结果|3808048|3808049|将这个帖子中的其他答案拼接在一起，我最终得到了|3808050|select+
++name,+type+
from+
++mysql.proc+
where+
++db+=+database()+
order+by+
++type,+name;|code-block|syntax|javascript|3808051|..。最终得到的结果如下所示：|3808052|mysql>+select+name,+type+from+mysql.proc+where+db+=+database()+order+by+type,+name;
%2B------------------------------%2B-----------%2B
%7C+name+++++++++++++++++++++++++%7C+type++++++%7C
%2B------------------------------%2B-----------%2B
%7C+get_oldest_to_scan+++++++++++%7C+FUNCTION++%7C
%7C+get_language_prevalence++++++%7C+PROCEDURE+%7C
%7C+get_top_repos_by_user++++++++%7C+PROCEDURE+%7C
%7C+get_user_language_prevalence+%7C+PROCEDURE+%7C
%2B------------------------------%2B-----------%2B
4+rows+in+set+(0.30+sec)|3808053|entityMap^0|0|0|0|0|B|5|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|15|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|16|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|17|8|@$J|18|K|19|L|M]]|9|@]|A|$]]|$1|N|3|O|5|E|7|1A|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1D|8|@]|9|@]|A|$V|W]]|$1|X|3|Y|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Z|3|10|5|U|7|1F|8|@]|9|@]|A|$V|W]]|$1|11|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|12|$]]

My preference is for something that:

<ol>
<li>Lists both functions and procedures,</li>
<li>Lets me know which are which,</li>
<li>Gives the procedures' names and types and nothing else,</li>
<li>Filters results by the current database, not the current definer</li>
<li>Sorts the result</li>
</ol>

Stitching together from other answers in this thread, I end up with

<pre><code>select 
 name, type 
from 
 mysql.proc 
where 
 db = database() 
order by 
 type, name;
</code></pre>

... which ends you up with results that look like this:

<pre><code>mysql&gt; select name, type from mysql.proc where db = database() order by type, name;
+------------------------------+-----------+
| name | type |
+------------------------------+-----------+
| get_oldest_to_scan | FUNCTION |
| get_language_prevalence | PROCEDURE |
| get_top_repos_by_user | PROCEDURE |
| get_user_language_prevalence | PROCEDURE |
+------------------------------+-----------+
4 rows in set (0.30 sec)
</code></pre>

blocks|key|3808157|text|显示所有存储过程：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3808158|SHOW+PROCEDURE+STATUS;|code-block|syntax|javascript|3808159|显示了所有函数：|3808160|SHOW+FUNCTION+STATUS;|3808161|显示指定过程的定义：|3808162|SHOW+CREATE+PROCEDURE+[PROC_NAME];|3808163|向您显示给定数据库的所有过程：|3808164|SHOW+PROCEDURE+STATUS+WHERE+Db+=+'[db_name]';|3808165|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Shows all the stored procedures:

<pre><code>SHOW PROCEDURE STATUS;
</code></pre>

Shows all the functions:

<pre><code>SHOW FUNCTION STATUS;
</code></pre>

Shows the definition of the specified procedure:

<pre><code>SHOW CREATE PROCEDURE [PROC_NAME];
</code></pre>

Shows you all the procedures of the given database: 

<pre><code>SHOW PROCEDURE STATUS WHERE Db = '[db_name]';
</code></pre>

blocks|key|3807747|text|使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3807748|SHOW+PROCEDURE+STATUS;|code-block|syntax|javascript|3807749|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

use this:

<pre><code>SHOW PROCEDURE STATUS;
</code></pre>

blocks|key|1153202|text|Praveenkumar_V的帖子的变体：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1153203|SELECT+`name`+FROM+mysql.proc+WHERE+db+=+'dbname'+AND+`type`+=+'PROCEDURE';
SELECT+`name`+FROM+mysql.proc+WHERE+db+=+'dbname'+AND+`type`+=+'FUNCTION';|code-block|syntax|javascript|1153204|..and这是因为我需要在做完一些家务活后节省时间：|1153205|SELECT+CONCAT(
+++++"GRANT+EXECUTE+ON+PROCEDURE+`"
++++,`name`
++++,"`+TO+username@'%25';+--+"
++++,`comment`
)
FROM+mysql.proc
WHERE+db+=+'dbname'
AND+`type`+=+'PROCEDURE';

SELECT+CONCAT(
+++++"GRANT+EXECUTE+ON+FUNCTION+`"
++++,`name`
++++,"`+TO+username@'%25';+--+"
++++,`comment`
)
FROM+mysql.proc
WHERE+db+=+'dbname'
AND+`type`+=+'FUNCTION';|1153206|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

A variation on Praveenkumar_V's post:

<pre><code>SELECT `name` FROM mysql.proc WHERE db = 'dbname' AND `type` = 'PROCEDURE';
SELECT `name` FROM mysql.proc WHERE db = 'dbname' AND `type` = 'FUNCTION';
</code></pre>

..and this because I needed to save time after some housekeeping:

<pre><code>SELECT CONCAT(
 "GRANT EXECUTE ON PROCEDURE `"
 ,`name`
 ,"` TO username@'%'; -- "
 ,`comment`
)
FROM mysql.proc
WHERE db = 'dbname'
AND `type` = 'PROCEDURE';

SELECT CONCAT(
 "GRANT EXECUTE ON FUNCTION `"
 ,`name`
 ,"` TO username@'%'; -- "
 ,`comment`
)
FROM mysql.proc
WHERE db = 'dbname'
AND `type` = 'FUNCTION';
</code></pre>

blocks|key|3807949|text|SELECT+specific_name+FROM+`information_schema`.`ROUTINES`+WHERE+routine_schema='database_name'|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3807950|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT specific_name FROM `information_schema`.`ROUTINES` WHERE routine_schema='database_name'
</code></pre>

blocks|key|4651437|text|要只显示您的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4651438|SELECT
++db,+type,+specific_name,+param_list,+returns
FROM
++mysql.proc
WHERE
++definer+LIKE
++CONCAT('%25',+CONCAT((SUBSTRING_INDEX((SELECT+user()),+'@',+1)),+'%25'));|code-block|syntax|javascript|4651439|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

To show just yours:

<pre><code>SELECT
 db, type, specific_name, param_list, returns
FROM
 mysql.proc
WHERE
 definer LIKE
 CONCAT('%', CONCAT((SUBSTRING_INDEX((SELECT user()), '@', 1)), '%'));
</code></pre>

blocks|key|1153305|text|如果要列出当前选定数据库存储过程，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1153306|SHOW+PROCEDURE+STATUS+WHERE+Db+=+DATABASE();|code-block|syntax|javascript|1153307|它将根据当前选定的数据库列出例程|1153308|更新了以列出数据库中的函数|offset|length|style|BOLD|1153309|select+*+from+information_schema.ROUTINES+where+ROUTINE_SCHEMA="YOUR+DATABASE+NAME"+and+ROUTINE_TYPE="FUNCTION";|1153310|要列出数据库中的例程/存储过程，|1153311|select+*+from+information_schema.ROUTINES+where+ROUTINE_SCHEMA="YOUR+DATABASE+NAME"+and+ROUTINE_TYPE="PROCEDURE";|1153312|要列出数据库中的表，|1153313|select+*+from+information_schema.TABLES+WHERE+TABLE_TYPE="BASE+TABLE"+AND+TABLE_SCHEMA="YOUR+DATABASE+NAME";|1153314|要列出数据库中的视图，|1153315|方法1:|1153316|select+*+from+information_schema.TABLES+WHERE+TABLE_TYPE="VIEW"+AND+TABLE_SCHEMA="YOUR+DATABASE+NAME";|1153317|方法2:|1153318|select+*+from+information_schema.VIEWS+WHERE+TABLE_SCHEMA="YOUR+DATABASE+NAME";|1153319|entityMap^0|0|0|0|0|3|0|0|0|0|0|0|0|0|4|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1D|8|@$K|1E|L|1F|M|N]]|9|@]|A|$]]|$1|O|3|P|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|D|7|1K|8|@]|9|@]|A|$E|F]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1M|8|@$K|1N|L|1O|M|N]]|9|@]|A|$]]|$1|12|3|13|5|D|7|1P|8|@]|9|@]|A|$E|F]]|$1|14|3|15|5|6|7|1Q|8|@$K|1R|L|1S|M|N]]|9|@]|A|$]]|$1|16|3|17|5|D|7|1T|8|@]|9|@]|A|$E|F]]|$1|18|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|19|$]]

If you want to list Store Procedure for Current Selected Database,

<pre><code>SHOW PROCEDURE STATUS WHERE Db = DATABASE();
</code></pre>

it will list Routines based on current selected Database

UPDATED
to list out functions in your database

<pre><code>select * from information_schema.ROUTINES where ROUTINE_SCHEMA="YOUR DATABASE NAME" and ROUTINE_TYPE="FUNCTION";
</code></pre>

to list out routines/store procedures in your database,

<pre><code>select * from information_schema.ROUTINES where ROUTINE_SCHEMA="YOUR DATABASE NAME" and ROUTINE_TYPE="PROCEDURE";
</code></pre>

to list tables in your database,

<pre><code>select * from information_schema.TABLES WHERE TABLE_TYPE="BASE TABLE" AND TABLE_SCHEMA="YOUR DATABASE NAME";
</code></pre>

to list views in your database,

method 1:

<pre><code>select * from information_schema.TABLES WHERE TABLE_TYPE="VIEW" AND TABLE_SCHEMA="YOUR DATABASE NAME";
</code></pre>

method 2:

<pre><code>select * from information_schema.VIEWS WHERE TABLE_SCHEMA="YOUR DATABASE NAME";
</code></pre>

blocks|key|3808301|text|从MySQL+8.0开始，删除了mysql.procs表。在此处使用此表的答案中运行任何命令都会产生一个错误，其内容如下(非常符合逻辑)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3808302|Table+'mysql.proc'+doesn't+exist|code-block|syntax|javascript|3808303|相反，要检索仅包含过程/函数名称的列表，请使用：|3808304|SELECT+specific_name+FROM+`information_schema`.`ROUTINES`+WHERE+routine_schema='<your_db_name>';|3808305|在我的例子中，我对它进行了编辑，使其只显示过程而不显示函数：|3808306|SELECT+specific_name+FROM+`information_schema`.`ROUTINES`+WHERE+routine_schema='<your_db_name>'+AND+routine_type='PROCEDURE';|3808307|entityMap^0|G|B|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|10|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

As of MySQL 8.0, the <code>mysql.procs</code> table has been removed. Running any of the commands from answers here that use this table will yield you an error that says (quite logically):
<pre><code>Table 'mysql.proc' doesn't exist
</code></pre>
Instead, to retrieve a list of only the names of procedures/functions, use:
<pre><code>SELECT specific_name FROM `information_schema`.`ROUTINES` WHERE routine_schema='&lt;your_db_name&gt;';
</code></pre>
In my case, I edited it to show only the procedures and not the functions:
<pre><code>SELECT specific_name FROM `information_schema`.`ROUTINES` WHERE routine_schema='&lt;your_db_name&gt;' AND routine_type='PROCEDURE';
</code></pre>

blocks|key|587030|text|我最喜欢呈现当前数据库的过程列表:名称、参数列表、注释|type|unstyled|depth|inlineStyleRanges|entityRanges|data|587031|SELECT+specific_name+AS+name,+param_list+AS+params,+`comment`
FROM+mysql.proc
WHERE+db+=+DATABASE()
AND+type+=+'PROCEDURE';|code-block|syntax|javascript|587032|添加函数的返回值：|587033|SELECT+specific_name+AS+name,+param_list+AS+params,+`returns`,+`comment`
FROM+mysql.proc
WHERE+db+=+DATABASE()
AND+type+=+'FUNCTION';|587034|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

My favorite rendering of the procedures list of the current database: name, parameters list, comment

<pre><code>SELECT specific_name AS name, param_list AS params, `comment`
FROM mysql.proc
WHERE db = DATABASE()
AND type = 'PROCEDURE';
</code></pre>

Add returns for functions:

<pre><code>SELECT specific_name AS name, param_list AS params, `returns`, `comment`
FROM mysql.proc
WHERE db = DATABASE()
AND type = 'FUNCTION';
</code></pre>

blocks|key|586654|text|+++++++++++++++++++++++++++show+procedure+status;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|586655|使用此命令可以查看数据库中的所有过程|unstyled|586656|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code> show procedure status;
</code></pre>

using this command you can see the all procedures in databases

blocks|key|587005|text|列出适用于all+databases的user's+procedures+and+functions|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|587006|SELECT+
++++`ROUTINE_SCHEMA`+AS+`database`
++++,`ROUTINE_TYPE`+AS+`type`
++++,`SPECIFIC_NAME`+AS+`name`
++++,`DTD_IDENTIFIER`+AS+`data_type`
FROM+
++++`INFORMATION_SCHEMA`.`ROUTINES`
WHERE
++`definer`+LIKE
++CONCAT('%25',+CONCAT((SUBSTRING_INDEX((SELECT+user()),+'@',+1)),+'%25'))
ORDER+BY
++++`database`
++++,`type`
++++,`name`
;|code-block|syntax|javascript|587007|列出user's中使用的数据库的过程和函数|587008|SELECT+
++++`ROUTINE_SCHEMA`+AS+`database`
++++,`ROUTINE_TYPE`+AS+`type`
++++,`SPECIFIC_NAME`+AS+`name`
++++,`DTD_IDENTIFIER`+AS+`data_type`
FROM+
++++`INFORMATION_SCHEMA`.`ROUTINES`
WHERE
++`definer`+LIKE
++CONCAT('%25',+CONCAT((SUBSTRING_INDEX((SELECT+user()),+'@',+1)),+'%25'))
AND
+++`ROUTINE_SCHEMA`+=+DATABASE()
ORDER+BY
++++`type`
++++,`name`
;|587009|entityMap^0|5|D|J|6|0|0|2|6|C|4|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|P|$]]

List user's procedures and functions for all databases:

<pre><code>SELECT 
 `ROUTINE_SCHEMA` AS `database`
 ,`ROUTINE_TYPE` AS `type`
 ,`SPECIFIC_NAME` AS `name`
 ,`DTD_IDENTIFIER` AS `data_type`
FROM 
 `INFORMATION_SCHEMA`.`ROUTINES`
WHERE
 `definer` LIKE
 CONCAT('%', CONCAT((SUBSTRING_INDEX((SELECT user()), '@', 1)), '%'))
ORDER BY
 `database`
 ,`type`
 ,`name`
;
</code></pre>

List user's procedures and functions for the database in use:

<pre><code>SELECT 
 `ROUTINE_SCHEMA` AS `database`
 ,`ROUTINE_TYPE` AS `type`
 ,`SPECIFIC_NAME` AS `name`
 ,`DTD_IDENTIFIER` AS `data_type`
FROM 
 `INFORMATION_SCHEMA`.`ROUTINES`
WHERE
 `definer` LIKE
 CONCAT('%', CONCAT((SUBSTRING_INDEX((SELECT user()), '@', 1)), '%'))
AND
 `ROUTINE_SCHEMA` = DATABASE()
ORDER BY
 `type`
 ,`name`
;
</code></pre>

blocks|key|3807976|text|对所有过程使用以下查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3807977|select+*+from+sysobjects+
where+type='p'
order+by+crdate+desc|code-block|syntax|javascript|3807978|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Use the following query for all the procedures:

<pre><code>select * from sysobjects 
where type='p'
order by crdate desc
</code></pre>

How can I see the list of the stored procedures or stored functions in mysql command line like <code>show tables;</code> or <code>show databases;</code> commands.

List of Stored Procedures/Functions Mysql Command Line

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

如何在mysql命令行中查看存储过程或存储函数的列表，如show tables;或show databases;命令。

问存储过程/函数列表Mysql命令行
EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问存储过程/函数列表Mysql命令行EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问存储过程/函数列表Mysql命令行
EN