If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Stored procedures

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 35
Stored procedures

Hi,
I am somehow new to Mysql and I have 2 questions that I would be grateful if anyone answered:
1. What are the internal (systematic) Stored Procedures in Mysql? (in MSSQL we have lots of them but I have not seen any for Mysql)
2. Do systematic Stored Procedures in Mysql get inputs from users?

Thanks
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 860
There are no specific procedures. However, there are some specific commands which will work instead such as "SHOW DATABASES", "SHOW TABLES". Hope this helps?
__________________
Ronan Cashell
Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
http://www.it-iss.com
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 35
Thanks for your answer, I was getting disappointed.
So, as I get from you answer we don't have internal SPs in Mysql as we have for example systematic, extended, ... SPs in MSsql.
Is that right?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 860
That is correct, these do not exist. You could write your own by accessing the schema database.
__________________
Ronan Cashell
Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
http://www.it-iss.com
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 35
Thank you very much indeed.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On