MySQL Cookbook: Solutions for Database Developers and Administrators

I wanted to have the honor of being the first person to review this amazing book. I hadn't purchased the previous edition but I saw that it received tons of good reviews on Amazon and this one came out like a day or two before I decided to buy it so I knew that the content would be up to date, which is always important when it comes to programming and web technology books; the landscape is constantly changing.I purchased the ebook version for $50.57 and I can say it was worth every sent and more! I purchased this title because I needed to learn more about MySQL so that I can build a web application that relies heavily on querying MySQL databases through PHP. I'm already several chapters in and I've learned far more in just a couple of days of reading and trying the examples in this book than I have from months of reading several other books and watching online tutorial videos which only skim the surface of what MySQL can do.This book teaches in a fun way with numerous helpful examples. I never thought that a MySQL book could be a page turner but it is; it's thrilling to read and I will treasure this book for many years to come, as I'm sure I'll need to go back to it whenever I'm stuck on a database issue. Please do yourself a favor and buy this book!!!

Good

I have to agree with Darkside that this book has some really cool stuff in here. And plan on covering every page of it. And will update this soon.F.Y.I. If you get a book with the Purple cover (not Red) on it, it is the 2014 book. And not the cheaper 30.00+ book. Yes, I freaked a little ....Ok alot. and made sure that it was the new and updated edition, and it is. And of course it arrived on-time and perfect condition, as promisedIf anything Amazon change the color of the book's picture to reflect the Purple cover. I said some pretty nasty things about you guys ......I am sorry ...hope that you can forgive me ? :)

Have not had time to read the whole book, but from everything I have read, I really like it. This book can help beginners to experts alike. Examples from Perl, PHP and Ruby, which if you like learning different languages, this part is great. Has lots of example queries and seems to keep security in mind. For example, there is a whole section on retrieving data and securely displaying it the user. Over 800+ pages will keep you busy for a while, and covers most everything MySQL. Good job Paul DuBois.

Handy reference for MySQL statements and a basic solutions. Kind of a quick at-a-glance book to give you examples on how to approach common problems. Useful for beginners and intermediates.

God book, lots of value for the money

Haven't really started using it yet. Have looked through it.

The cookbook has a lot of examples that stretch across the normal use of MySQL and is written in a structured manner. It may take a while to increase in complexity, but builds a good base.

Disappointed. I don't rate this as a "MySQL Cookbook". I think it's more at SQL beginner level than cookbook level, but there are other better books and web articles for (My)SQL beginners.Where am I coming from? I'm new to MySQL/MariaDB but have 20+ years with Oracle SQL*Plus and PL/SQL, 40+ years in IT with a lot of database design, data and systems analysis, reporting, IT architecture and some development work.I don't rate this book well because:- You'll get a lot more MySQL info from (Oracle's) MySQL Reference Manual. I was looking for something that adds to/expands on the Ref Manual, but with respect to MySQL this book largely, in my opinion, rehashes bits from the Ref. Manual.- It's not what I'd call an IT Cookbook! Most of the examples are pretty trivial and not that helpful. It's all low level stuff. There's little I'd use in serious SQL development work.- 50% or so of the book is about PHP, Perl, Ruby, Java rather than MySQL.- It's too verbose where tighter, cleaner explanations would be clearer.- It does n't tackle critical (My)SQL areas well (or some at all), like exception handling and debugging, real SQL querying, code structuring and efficiency.- Multi-table (i.e. 3+ table) joins are barely mentioned, yet are critical to realistic queries and SQL performance.- Time period handling, which is a Cookbook level topic, isn't mentioned. (Time and date datatype handling are.)- It's expensive, both in £ and pages, for what it provides.

Comprehensive, and very informative. Monsieur DuBois is a Guru and very capable of explaining concepts in such a way to make it easy for the novice to understand clearly. Highly recommended.

Very good instruction book for learning MySQL very easy to understand the writing style of Paul DuBois

Pour qui est un habitué des "cookbook", ceux-ci s'adressent généralement, comme on peut l'imaginer, à des personnes ayant une connaissance relativement superficielle d'un sujet et qui souhaitent le voir à l'œuvre dans les mains de quelqu'un d'expérimenté sur des problématiques concrètes.Or ce livre de recette livre est en fait en grande partie une introduction au langage SQL.Exemples de recettes: "You want to display specific columns and rows from a table", Solution: "Name columns in the output columns list, use a WHERE clause that specifies conditions". "You want to create a table that has the same structure as an existing table", solution "use CREATE TABLE LIKE".Certes les solutions sont suivies de digressions pas toujours inintéressantes, mais on ne s'éloigne jamais vraiment du niveau débutant en SQL en ce sens où la réponse à la majorité des questions est simplement un mot clé du langage SQL. Je pense qu'un livre comme "Learning SQL" est beaucoup plus efficace car allant droit au but sans utiliser le truchement de "recettes" artificielles pour introduire des fonctionnalités du langage -- avec de surcroît une couverture plus large.Quiconque ayant déjà une vague connaissance de SQL comme moi n’apprendra grand-chose de ce livre. Par ailleurs la plupart des exemples sont relativement mauvais dans le sens où ils ne suivent pas les bonnes pratiques de normalisation — ce qui est peut-être normal si l'on considère que l'on n'a pas à connaître JOIN avant qu'il ne soit introduit au chapitre 14, mais qui me semble tout le contraire de ce que l'on attend d'un livre de recettes.Les seules parties plus intéressantes sont celles qui sont spécifiques à MySQL, tant au niveau du dialecte SQL que de l'utilisation du serveur et du client. Celles-ci sont toutefois peu nombreuses et relativement superficielles. Il n'y a par exemple quasiment rien sur les procédures stockées dans la base, ce qui est bien dommage.

Ich bin mit dem MySQL Cookbook sehr zufrieden. Als Cookbook liefert es Lösungsansätze für typische MySQL Probleme. Eine gute Ergänzung, aber bitte nicht mit einem Lehrbuch verwechseln.