MySql and stored procedures - a good tutorial? - Databases forum at WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

MySql and stored procedures - a good tutorial?

Tutorials, links and advices welcome

Sylver

2:57 pm on Sep 8, 2007 (gmt 0)

I would like to handle most of the data input/output of my databases using stored procedures.

Usually, I handle all the data processing part from PHP and load the data when they are ready, but stored procedures would be more secure and perhaps more efficient too.

I am developping an application to handle a relatively small volume of data (a few thousand rows in 20+ tables per database and a handful of users)

Does anyone know where I can find a good tutorial?

coopster

5:49 pm on Sep 10, 2007 (gmt 0)

You will likely find some information on their community pages [dev.mysql.com] such as this page [dev.mysql.com] but a search on "sql stored procedure tutorial" may be helpful as well.

Sylver

1:33 am on Sep 11, 2007 (gmt 0)

Thanks, I do have the manual, and I can search Google.

However the references I found were not that good as I am quite new to the subject, and I was hoping for someone to recommend a particular tutorial.