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
O’Reilly, the premier learning platform for technology professionals, offers the industry’s most extensive catalog of high-quality technical and professional skills development courses. From AI, programming, and cloud technologies to essential business skills such as leadership training and critical thinking, O’Reilly delivers highly trusted content from its network of renowned experts that meets a diverse array of learning needs, with over 5,000 role-based on-demand courses, nearly 200 live events each month, access to interactive sandboxes and labs, and more. For more information, visit www.oreilly.com.