With Early Release ebooks, you get books in their earliest form — the author's raw and unedited content as he or she writes — so you can take advantage of these technologies long before the official release of these titles. You'll also receive updates when significant changes are made, new chapters as they're written, and the final ebook bundle.
MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.
This third edition has been updated to cover new APIs in Python and PHP, as well as powerful new features in MySQL 5.6 and older versions still in common use. Recipes use the mysql client program as well as Java, Perl, PHP, Python, and Ruby APIs.
Sort rows in common ways and use aggregate functions to summarize rows
Find matches or mismatches between rows in two tables
Determine intervals between dates or times, including age calculations
Store images into MySQL and retrieve them for display in web pages
Use strict mode to prevent entry of bad data into your database
Copy a table or a database to another server
Create database events that execute according to a schedule
Paul DuBois was one of the first contributors to the online MySQL Reference Manual, a renowned documentation project that supported MySQL administrators and database developers in the first few years of MySQL's existence in the late 1990's. Paul went on to write more than six books on MySQL, including the first edition of "MySQL Cookbook". He is also the author of "Using csh & tcsh" and "Software Portability with imake", both by O'Reilly.
The animal on the cover of MySQL Cookbook, Third Edition is a green anole. Thesecommon lizards can be found in the southeastern United States, the Caribbean, andSouth America. Green anoles dwell in moist, shady environments, such as inside treesand shrubs. They subsist on small insects like crickets, roaches, moths, grubs, and spiders.Green anoles are slight in build, with narrow heads and long, slender tails that can betwice as long as their bodies. The special padding on their feet enables them to climb,cling to, and run on any surface. They range in size from six to eight inches long. Though,as their name implies, green anoles are usually bright green, their color can change tomatch their surroundings, varying among gray-brown, brown, and green. Male anoleshave pink dewlaps that they extend when courting or protecting their territory.
While this book is not complete I believe that so far it has been very useful and informative. I would say I am fairly familiar with this topic, but it has some great examples of how to interface with different programming languages and APIs that I find very useful. I will give it 5 stars for now, but would like to see more before I say it actually deserves a 5.
Bottom Line Yes, I would recommend this to a friend