I am trying to figure out the best way to determine if a mysql database uses stored procs or not. It's not a home grown database... open source stuff. I found another post here: Find all MySQL Stored Procedure calls?
我试图找出确定mysql数据库是否使用存储过程的最佳方法。它不是一个本土的数据库......开源的东西。我在这里找到了另一篇文章:查找所有MySQL存储过程调用?
Based on that post, I've tried the following:
基于该帖子,我尝试了以下内容:
mysql> SELECT * FROM information_schema.ROUTINES
-> ; Empty set (0.00 sec)
mysql>
Can I safely assume then that this database has no stored procs? Thanks!
我可以安全地假设这个数据库没有存储过程吗?谢谢!
1 个解决方案
#1
0
With the Query you posted, you are correct in making that assumption. I tested it on a local database with no Stored Procs and got the same result. I created a test stored proc, re-ran that same query and got a single result (with the proc I created).
使用您发布的查询,您在做出该假设时是正确的。我在没有存储过程的本地数据库上测试它并获得相同的结果。我创建了一个测试存储过程,重新运行相同的查询并得到一个结果(使用我创建的proc)。
#1
0
With the Query you posted, you are correct in making that assumption. I tested it on a local database with no Stored Procs and got the same result. I created a test stored proc, re-ran that same query and got a single result (with the proc I created).
使用您发布的查询,您在做出该假设时是正确的。我在没有存储过程的本地数据库上测试它并获得相同的结果。我创建了一个测试存储过程,重新运行相同的查询并得到一个结果(使用我创建的proc)。