Press Release: November 20, 2002
"MySQL Cookbook" from O'Reilly is Chock-full of Code "Recipes"
Sebastopol,CA--With a reputation for being powerful and flexible, as well as lightweight and efficient, MySQL is one of the most widely used databases in the world. Among its three million plus installations, you can find high-profile users such as Yahoo!, NASA, Silicon Graphics, and the US Census Bureau. Lured by its small price tag (free for noncommercial use) and its ability to handle very large data sets, millions of users--from enterprise database administrators to small organizations or web sites--have chosen MySQL over rival, proprietary database solutions. And now, with the help of O'Reilly's new MySQL Cookbook by Paul Dubois (US $49.95), they no longer have to create their databases from scratch.
"MySQL Cookbook" provides a unique Problem/Solution/Discussion format that offers quick solutions to everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--a short, focused, ready-to-use piece of code. But "MySQL Cookbook" is more than a collection of cut-and-paste code. The discussion section explains how and why the code works, so readers can learn to adapt the techniques to similar situations. The source code and sample data used throughout the book are available at a companion web site, www.kitebird.com/mysql-cookbook/. Author (and network database administrator) Paul DuBois made sure his book is relevant to all levels of MySQL users, on several different platforms.
"Many people sense how powerful a tool MySQL is, but don't have a lot of training to draw on when faced with common, database-related tasks. This book provides the how-to that will enable them to solve problems and exploit MySQL more fully," said DuBois. "Experienced MySQL users will find the book contains a tremendous amount of code that can be used directly or adapted to similar problems. These 'recipes' save time by making it easier to develop applications without writing everything from scratch."
From simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables, "MySQL Cookbook" addresses the real-world challenges that database administrators face every day. Unix, Linux, Windows, and Mac OS X users will learn how to:
- Import data from external sources
- Export data for use by external programs
- Access MySQL from your web server
- Use scripts with MySQL to read queries from a file
- Access MySQL from within client programs that use Perl, PHP, Java, Python, and other languages
- Construct queries that solve commonly occurring questions
- Identify, count, and remove duplicate records
"MySQL Cookbook" supplies readers with an armory of ready-made techniques and tools. It's a book that MySQL users will turn to again and again as they build and tune their databases.
Chapter 3, Record Selection Techniques is available free online