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.
Additional Resources:
Chapter 3, Record Selection Techniques is available free online
More information about the book, including Table of Contents, index, author bio, and samples
MySQL Cookbook
Paul DuBois
October 2002
ISBN: 0-596-00145-2, 1022 pages, $49.95 US, $77.95 CA
order@oreilly.com
1-800-998-9938; 1-707-827-7000
About O’Reilly
For over 45 years, O’Reilly has provided technology and business training, knowledge, and insight to help companies succeed. Our unique network of experts and innovators share their knowledge and expertise through the company’s SaaS-based training and learning platform. O’Reilly delivers highly topical and comprehensive technology and business learning solutions to millions of users across enterprise, consumer, and university channels. For more information, visit www.oreilly.com.