MySQL Cookbook (First Edition) Paul DuBois O'Reilly & Associates, October, 2002 1022 pages ISBN: 0-596-00145-2 larger image

Welcome to the Web site for MySQL Cookbook, First Edition. The most current printing is the Second Edition.

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
• Examples
• Downloads
• Errata
• Reviews
• Publishers's listing: oreilly.com
  (book listing includes sample chapter; note that it's one of the most basic chapters in the book)
• Excerpts from ONLamp.com:
  • [excerpt 1] Summaries and NULL values; Counting and identifying duplicates
  • [excerpt 2] Managing multiple simultaneous AUTO_INCREMENT values; Using AUTO_INCREMENT values to relate tables
  • [excerpt 3] Computing team standings; Calculating differences between successive rows; Finding cumulative sums and running averages
  • [recipe of the day] various short excerpts
• Excerpt: "What To Do if mysql Cannot Be Found" (how to set your PATH) [PDF]
• Bookseller listings: [Amazon] [Bookpool]  disclaimer
• The book is available in electronic form at Safari
• Translations
• Larger cover image: [PDF] [JPEG]