Results 1 to 5 of 5
  1. #1
    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

  2. #2
    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

  3. #3
    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?

  4. #4
    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

  5. #5
    Join Date
    Jan 2013
    Posts
    35
    Thank you very much indeed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •