MySQL Stored Procedures Limitation

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
Darrell JamesDirector of Information TechnologyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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...
0
 
Darrell JamesDirector of Information TechnologyAuthor Commented:
Thanks so much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.