What good guides do you know about MySQL stored procedures?

Question

I want to write a stored procedure to increase the value of an int column by one. Looks like a very simple task, but not for someone who has no experience with stored procedures.

To do this, I searched for tutorials and code samples, and found several, but I’m sure that there are better ones. Do you know anyone?

I found:

• http://dev.mysql.com/doc/refman/5.0/en/call.html (sample code)
• http://www.databasejournal.com/features/mysql/print.php/3525581
• http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000297.html
• http://www.devshed.com/c/a/MySQL/A-DIY-Approach-to-Stored-Procedures-in-MySQL/
• http://www.phpbits.info/mysql-tutorial/stored-procedures-in-mysql/
• http://www.kbedell.com/2009/03/02/a-simple-example-of-a-mysql-stored-procedure-that-uses-a-cursor/

Answer 1

It is in German, but it is good. http://www.tutorials.de/forum/sql-tutorials/179510-stored-procedures-mysql-5-a.html

In English, I think the material in this place is beautiful. You have many different lessons. http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

Answer 2

I would recommend building a copy of MySQL Second Edition from Larry Ullman . He has a good overview of stored procedures. This, combined with the textbooks you have already found, should give you a good start with them.