O'Reilly & Associates, October, 2002
Welcome to the Web site for MySQL Cookbook, First Edition.
The most current printing is the
The book covers techniques for solving many different SQL problems, and
how to write your own MySQL programs using Perl, PHP, Python, and Java.
It is written in problem-and-solution format to make it easy for you to find
the answers to your questions.
It contains SQL-only recipes, command line scripts, and web scripts (using
Apache for Perl, PHP, and Python; and Tomcat for Java and JSP/JSTL).
- Table of contents
(book listing includes sample chapter;
note that it's one of the most basic chapters in the book)
Excerpts from ONLamp.com:
Summaries and NULL values;
Counting and identifying duplicates
Managing multiple simultaneous AUTO_INCREMENT values;
Using AUTO_INCREMENT values to relate tables
Computing team standings;
Calculating differences between successive rows;
Finding cumulative sums and running averages
[recipe of the
various short excerpts
Excerpt: "What To Do if mysql Cannot Be Found"
(how to set your PATH)
The book is available in electronic form at
Larger cover image:
Inquiries may be sent to
Last modified: April 12, 2007
[MySQL and Perl for the Web]