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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.