A Look Inside MySQL 5.0 for Developers

[mandy]

Article covers Syntax, Stored Procedure Examples, Stored Function Examples, and Declaring Variables Within Procedures in MySQL 5.0

It’s difficult to say which is the greater source of excitement surrounding MySQL 5.0—the arrival of stored procedures in MySQL, or the appearance of views. In this section, we’ll discuss both of these features in detail. We’ll define and explain the concepts behind both stored procedures and views, and show you some working examples of each. (Of course, when we say “working,” we mean that these examples will work if you try them on an installation of MySQL 5.0.1 or newer.) We’ll also talk about how these features will help to improve your MySQL applications in terms of both efficiency and security...

full article: http://www.devshed.com/c/a/MySQL/Examining-MySQL-50/