MySQL Cookbook, 3rd Ed

Author: Paul DuBois
Publisher: O'Reilly
Pages: 836 
ISBN: 9781449374020
Print:1449374026
Kindle: B00M7EN798
Aimed at: MySQL developers
Rating: 5
Reviewed by: Kay Ewbank 

Is MySQL Cookbook the best book on MySQL? This latest edition certainly keeps up its reputation as the go-to reference.

This is the third edition of one of the best books on MySQL. The subtitle of the book is ‘Solutions for database developers and administrators’, and that sums up the content perfectly. This isn’t an intro for beginners as it assumes a basic level of knowledge about MySQL. Having said that, the book starts with an intro to the MySQL client program, followed by a chapter on writing MySQL-based programs showing topics such as how to connect to the server and issue queries. Dubois uses a mix of Perl, Ruby, PHP, Python and Java in his examples throughout the book. The book is organized into sections each posing a problem you might face, followed by the solution in one of the example languages, and a discussion of the techniques used. 

 

Banner

 

Having introduced the basics, Dubois moves on to the essentials of selecting data from tables using the Select statement. The administrator element of the book is apparent in the next chapter, which covers table management and topics such as copying results between tables, cloning tables, and changing a table’s storage engine. There are a couple of solid chapters on strings, dates and times, and the section on queries concludes with chapters on sorting query results and generating summaries. There’s a good chapter on stored routines, triggers and scheduled events, though I’d have liked to see more ‘recipes’ – the chapter has three on stored procedures, four on triggers, and three on events.

Metadata and how to work with it is the next topic, with a good description of what metadata is and how to use it. This is followed by chapters on importing and exporting data, and on validating and reformatting the data once you’ve imported it. A chapter on generating and using sequences has useful descriptions of how to find the most recent value and how to re-sequence a column, and there’s a solid chapter on using joins and subqueries.

From this point onwards the book gets more interesting for developers who already know the basics of working with databases. There’s a good chapter on statistical techniques covering frequency distributions, regressions and correlations. A chapter on handling duplicates shows how to find and remove duplicates, and more usefully how to stop them happening in the first place. The chapter on handling transactions discusses how to write transactional code in all the example languages – Perl, Ruby, PHP, Python and Java.

 

mysqlcookbook

 

 

The next four chapters discuss using MySQL on the web, including generating web content from query results, processing web input, and MySQL web-session management. The book closes with chapters on server administration and security.

This is a very thorough book that gives good examples throughout. DuBois does assume a certain level of knowledge about SQL and MySQL, so I wouldn’t recommend the book for a beginner, but if you want to learn more about the workings of MySQL you’ll certainly find useful information. I’d describe the coverage as broad rather than really in-depth; the descriptions tell you what to do in specific situations, but don’t go into the underlying reasons why a particular choice has been made, what your alternatives are, or why this method works.

My overall impression of the book is that if you’re trying to work out how to do something specific in MySQL, the chances are DuBois will have a solution showing how to achieve your aim. It’s a very good addition to any MySQL bookshelf.  

Related Review

MySQL 5th Edition 

Author: Paul DuBois
Publisher: Addison Wesley,  2013
Target audience: Developers working with MySQL
Rating: 5
Reviewed by: Kay Ewbank

This is a very good book for anyone needing to know how to use MySQL. It has good descriptions of even difficult topics, and the examples are well written and good at illustrating the point.  A book you’ll want to keep on your desk when learning MySQL, and on the shelf once you know it for those occasions when you meet something incomprehensible.

 

Banner


SQL Server 2022 Administration Inside Out

Author: Randolph West et al
Publisher: Microsoft Press
Pages: 992
Print: 0137899882
ISBN: 978-0137899883
Kindle: B0C4VKVP27
Audience: DBAs and developers
Rating: 5.0
Reviewer: Ian Stirk

This book aims to update your DBA skills to cover SQL Server 2022, how does it fare?



Embedded Vision: An Introduction (Mercury Learning)

Author: S. R. Vijayalakshmi and S. Muruganand
Publisher: Mercury Learning
Date: October 2019
Pages: 580
ISBN: 978-1683924579
Print: 1683924576
Kindle: B07YN6JC19
Audience: Developers interested in vision-enabled devices
Rating: 3
Reviewer: Harry Fairhead
The power of small machines is now well able to ta [ ... ]


More Reviews

<ASIN:0321833872>

 

 

Last Updated ( Saturday, 27 December 2014 )