12. Techniques for Programming

This, the fourth and final programming chapter of the book, will show you some specific ways of using programming languages to interface with MySQL. Whereas chapters 7 through 9 demonstrate how to do basic MySQL interactions with PHP, Perl, and Java, the focus here is more on theory and techniques: how to do certain things using a programming language. The particulars to be discussed include storing and retrieving binary data, generating query result pages, using transactions, and calling stored procedures.

The techniques demonstrated in this chapter cover a handful of what I believe are the more commonly needed programming topics. I’ll be showing one workable solution to each of the quandaries. While you will most ...

Get MySQL, Second Edition: Visual Quickstart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.