Solved

MySQL Stored Procedures Limitation

Posted on 2012-03-13
2
286 Views
Last Modified: 2012-03-13
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
0
Comment
Question by:darrellajames
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:darrellajames
Comment Utility
Thanks so much.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now