04-28-2006, 11:39 AM
Article covers Syntax, Stored Procedure Examples, Stored Function Examples, and Declaring Variables Within Procedures in MySQL 5.0
full article: http://www.devshed.com/c/a/MySQL/Examining-MySQL-50/
Quote:Its difficult to say which is the greater source of excitement surrounding MySQL 5.0the arrival of stored procedures in MySQL, or the appearance of views. In this section, well discuss both of these features in detail. Well 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.) Well 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/