MySQL Cookbook

For everyday programming dilemmas and data manipulation challenges, MySQL Cookbook offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time or expertise to solve MySQL problems from scratch. Each recipe explains how and why the code works, so you'll learn as you go.

This new edition covers MySQL 5.0 and its powerful new features, along with the older but still widespread MySQL 4.1. You'll find ways to formulate queries with SQL using the mysql client program and methods for writing programs that interact with the MySQL server through an API. There are plenty of new examples for using Perl, PHP, Python, Java, and even Ruby to retrieve and display data. And the book is now updated to include subqueries, views, stored routines, triggers, and events.

This quick-solution resource also offers recipes to: Access data from multiple tables at the same time, Find matches or mismatches between rows in two tables, Store images into MySQL and retrieve them for display in web pages, Enable strict mode to prevent entry of bad data into your database, Create database events that execute according to a schedule. MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it assists you in developing applications yourself by helping you get past problems that have you stumped.

DuBois provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that readers can insert directly into their applications.