Stored Routines
Apress eBooks · 2008
Throughout this book you’ve seen quite a few examples where the MySQL queries were embedded directly into the PHP script. Indeed, for smaller applications this is fine; however, as application complexity and size increase, continuing this practice could be the source of some grief. For instance, what if you have to deploy two similar applications, one desktop-based and the other Web-based, that use the MySQL database and perform many of the same tasks? On the occasion a query changed, you’d need to make modifications wherever that query appeared not in one application but in two! These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.