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

Does anybody here use MySQL stored procedures?

techguy · 2010-04-08 21:38:32

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.

Options

08-04-2010 10:38pm

#1

techguy

Registered Users Posts: 2,234 ✭✭✭

Join Date: June 2004

Posts: 1635

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.

1

Comments

Options
#2 10-04-2010 1:08pm
wapnote

Closed Accounts Posts: 43 ✭

Join Date: February 2010

Posts: 40

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.

0
Options
#3 10-04-2010 6:22pm
Freddio

Registered Users Posts: 647 ✭✭✭

Join Date: March 2010

Posts: 607

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

0