Stored Procedure Programming for MySQL5 - PART 1

Marcus Whitney, the editor of A/R/T, has published a 5 page tutorial titled Stored Procedure Programming for MySQL5 – PART 1. Written by Ligaya Turmelle, it is designed to ease PHP programmers into the concepts behind stored procedures.

We will go over some basic concepts involved, some background information you may or may not know and then break a couple of examples down line by line to help you understand what is happening. I won’t bore you with basic programming information – that you should know already. However I will be going over what differentiates stored procedure programming from PHP programming. So sit back and relax as we go for a bit of a ride. And please remember to place your trays in the full upright position and to keep your hands and feet inside the vehicle at all times.

Ligaya does a good job of explaining the basics and walking you through 2 examples that almost anyone who has spent time with a database server can grasp. As anyone who has read more than one of my news reports here knows, I’m a fan of injecting a little humor in everyday life. Ligaya is a woman after my own heart. It’s rare that you find a good technical writer who can weave subtle humor into an article and not have it look out of place. I think she sums it up best in her bio at the end.

Ligaya Turmelle is a full time Goddess, occasional PHP programmer, and obsessive world traveler. She currently lives in Guam with her husband and daughter and their 2 Belgian Malinois. Actively involved with the PHP Community she hopes to one day actually meet the people she talks to.

Between the humor and the code Ligaya manages to give readers a taste of stored procedures. Not enough yet to actually go write an application on your own but certainly enough to make you want Part 2.

=C=