| Overview
While MySQL has turned up among high profile users such as Yahoo!,
NASA and the U.S. Census Bureau, the rising popularity of this open
source database is especially keen among users with little database
experience. These days, even a small organization or web site has
uses for a database, and MySQL is an obvious choice. Affordable and
easy to use, MySQL packs the power, speed and efficiency that
enable it to rival expensive, proprietary database solutions. Yet,
even if you know the basics, anyone without practical MySQL
experience--novices and skilled DBAs alike--might stumble over
common database-related tasks. Fortunately, there's a sensible
shortcut. MySQL Cookbook provides a unique
problem-and-solution format that offers practical examples for
everyday programming dilemmas. For every problem addressed in the
book, there's a worked-out solution or "recipe"--short, focused
pieces of code that you can insert directly into your applications.
But MySQL Cookbook is more than a collection of
cut-and-paste code. You also get explanations of how and why the
code works, so you can learn to adapt the techniques to similar
situations. The book covers a lot of ground. Solutions for typical
MySQL dilemmas range 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. Whether you use MySQL
on Unix, Linux, Windows or the Mac OS X platform, the book will
show you 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 Interact with the server
This learn-as-you-go resource will help users of all levels exploit
MySQL more fully. MySQL Cookbook supplies you with an armory
of ready-made techniques for specific problems so that, even if
you're an experienced MySQL user, you don't have to write
everything from scratch.
Editorial ReviewsAmazon.comGood programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process. DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques. | Product DescriptionWhile MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut. MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations. The book covers a lot of ground. Solutions for typical MySQL dilemmas range 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. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you 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
- Interact with the server
This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch. |
Top Sellers in This Category | Browse Similar Topics | | Top Level Categories:Sub-Categories: | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 25 reviews. excellent resource, 2008-04-10 Reviewer rating: This book is
-a great resource for those looking to implement various mysql functions
-a great resource for database programmers
-a trove of information on powerful query and sort techniques
Finding information about the topic you're looking for is a breeze in this book - the chapters are well-organized, and this book has anwered all questions I've posed to it....
The cookbook is a powerful tool to those who know some mysql, and some dB design. I recommend that you use another book to learn basic mysql (or just an online tutorial), and another to learn database design (Navathe). | True to the Title, 2008-03-11 Reviewer rating: As indicated, this book is true to its title. It is a cookbook, by which I mean it contains a great number of (generally useful) recipes of varying complexity, but lacks detail and analysis that a more focused text would have.
Mr. DuBois and O'Reilly publishing are clearly targeting a wide audience: the recipes range from frighteningly simple (e.g. 3.1, Specifying Which Columns to Select) to fairly sophisticated (e.g. 12.14, Performing a Join Between Tables in Different Databases). The recipes are typically clearly written, with ample supporting code examples and few typographical errors.
I must also note that Mr. DuBois nicely avoids a pitfall many authors (the competence of whom I have to question) in this genre encounter: failure to weave security considerations into the text. While other books often mention security as an afterthought, or worse include code examples featuring disasters like non-escaped strings (hello, SQL injection!), DuBois explicitly points out the need to sanitize input and writes code examples that demonstrate the use of prepared statements in best-practices.
Unfortunately, in other areas he is less thorough. For example, only passing mention is made of the (possible) dependence of FULLTEXT indexes on choice of storage engine. There is an entire chapter on handling duplicate rows, but the oft-needed (and non-obvious) process for removing pseudo-duplicate rows differing only by a primary key field is not directly addressed. Stored procedures, triggers, and other new additions to MySQL are among the least-well understood but most powerful features of the database engine, yet astonishingly little space is spent on them. (I could understand not discussing them in depth as there are other books available, but length did not seem to be a concern anywhere else in this book.)
In summary, the book is an excellent resource for novices and experts alike - but only as a starting point. To return to the cooking analogy, the book at times feels like it is loaded down with recipes on how to add sugar to flour, but omits recipes on how to ice the cake. | Useful book, 2007-12-30 Reviewer rating: This book is useful for anyone looking to find examples of MySQL 4 usage in multiple languages such as PHP, Perl, Java, and Python. It covers many areas that are used in real world applications and is great as a reference material. This book is structured in the Problem/Solution layout of the Oreilly cookbook series. | Excellent book, 2007-12-21 Reviewer rating: While I'm very familiar with working with relational databases, my MySQL skills are weak. This book was exactly what I needed while building a new web application that uses MySQL. For every question I had, I found the answer in this book. Highly recommended. | For "anybody who uses MySQL", 2007-12-16 Reviewer rating:
Visuals
Good. Page numbers and section title can be found on the bottom of every page.
Audience
From the book: "This book should be useful for anybody who uses MySQL, ranging from individuals [...] to professional database and web developers."
That is a pretty broad range, basically from introductory to advanced. Nevertheless I would have to say that the book meets this challenge well. This book should be of use to anybody who uses MySQL.
Practicality:
I have to say that I have fallen for Cookbook style books. While I still thoroughly enjoy more theory heavy books, cookbooks can really deliver in the immediate practicality department.
The MySQL Cookbook is a good example of this. This book has dozens upon dozens of recipes that will likely have some measure of application in whatever MySQL dependent system you are working on.
Each recipe contains a brief "Problem" scenario, followed by an often equally brief "Solution", and finally a more lengthy discussion that shows how to actually implement the solution.
Overall
I am very pleased with this book. Mr. DuBois and O'Reilly did a great job. For instance, one of the things I especially like is that often multiple solutions are offered. For example if you were to look up Section 6.6 "Extracting Parts of Dates or Times" you will find the solution lists 3 possible options. The discussion section contains 5 pages of examples of how you might use those options to extract the desired data.
If you fit in to the intended audience of "anybody who uses MySQL", I would highly recommend this book. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|