如何在 phpMyAdmin 中查看我的存储过程?

2021-12-20 00:00:00 sql mysql phpmyadmin stored-procedures

我在 phpMyAdmin 中创建了一个存储过程

I created a stored procedure in phpMyAdmin

CREATE PROCEDURE Sample()
SELECT * FROM feedback

在哪里可以查看此过程?如果在 phpMyAdmin 中不可能,那么有哪些好的程序可以编写、存储和查看存储过程、表等?

Where could I view this this procedure? If it's not possible in phpMyAdmin, what is/are some good program(s) that have the feature to write, store, and view stored procedures, tables, etc?

推荐答案

在phpmyadmin中查看存储过程:

查询:

SELECT routine_definition
FROM information_schema.routines
WHERE 
routine_name = 'procedure_name' AND routine_schema = 'databasename';

这里是如何在 phpmyadmin 中到达那里.

Here's how to get there in phpmyadmin.

routines 选项在 phpmyadmin 中可用.在您至少拥有一个存储过程之前,该链接在 PHPmyadmin 中不可见.查看上图,然后单击 structure 选项卡下的 routines 链接.

The routines option is available in phpmyadmin. The link is not visible in PHPmyadmin until you have at least one stored procedure. See the above image and click the routines link under structure tab.

相关文章