Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Does anybody here use MySQL stored procedures?

  • 08-04-2010 9:38pm
    #1
    techguy
    Registered Users, Registered Users 2 Posts: 2,236 ✭✭✭


    Hi,

    I was reading about stored procedures earlier and they seem fairly interesting. I can see how they would make my life easier.

    Does anybody else use these in their apps? Are the complicated to use and are there any major disadvantages to consider?

    Thanks.


Comments

  • #2
    wapnote
    Closed Accounts Posts: 43 ✭wapnote


    I use MySql SPs in my application.

    They aren't that difficult to use, and are useful.

    The only problem I had with them was that PhpMyAdmin doesn't support SPs, so you will need to be able to access your database with an IDE like Toad.


  • #3
    Freddio
    Registered Users, Registered Users 2 Posts: 648 ✭✭✭Freddio


    If its cursors you need, it might be easier to write sql in a web scripted file (that is if its a web database) but if its triggers you need then programming the database would be more effective

    MySQL provide the tools to connect to databases to do this for free


Advertisement