We help IT Professionals succeed at work.

MySQL Stored Procedures Limitation

Darrell James
on
Hello All,

I am moving from MSSQL over to MySQL and I have a simple question, is there a limit to the number of stored procedures you can have in a database?  Basically, I've success in creating the sps, however they do not exist on the list or when I call them.  I seem to only be able to store 3 procedures. The 3 that are there run fine but I have the written 9 so far.  I have search all over with no luck, any assistance would be greatly appreciated.

Thanks,
Darrell
Comment
Watch Question

Billing Engineer
GOLD EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
there is no limit of number of stored procedures, for sure not 3 or 9.
you might check if you did not create them in another database that your user database...
Darrell JamesDirector of Information Technology

Author

Commented:
Thanks so much.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.