|Title||:||MySQL & mSQL by Randy Jay Yarger (2000-04-01)|
|Publisher||:||O Reilly Verlag GmbH Co KG 1771|
|Number of Pages||:||406 Pages|
|File Size||:||570 KB|
|Status||:||Available For Download|
|Last checked||:||21 Minutes ago!|
MySQL & mSQL by Randy Jay Yarger (2000-04-01) Reviews
Ich bin mit dem Buch "MySQL and mSQL" von Randy Yarger, George Reese und Tim King nicht wirklich zufrieden. Ich hatte gehofft, hier ein Buch zu finden, das die umfangreiche MySQL-Dokumentation ersetzt und zusätzlich noch viele Beispiele und Problemlösungen bietet. Dieses Buch bietet eine nette Einführung in SQL und die Grundlagen von Datenbank-Design. Die Kapitel über Datenbank-Programmierung können aber eher als halbherziger versuch gewertet werden. So wird sich zwar der CGI-Spezifikation in einiger Länge gewidmet, die Beispiele sind eher wenig sinnvoll gewählt. Auch bei der Behandlung von Perl gefällt mir das Beispiel überhaupt nicht, weil es viel zu lang und umfangreich geraten ist, als dass ich es auf einen Blick nachvollziehen kann. PHP wird auf zwei Seiten abgehandelt, andere Sprachen kommen ebenfalls sehr kurz weg. Lediglich die anhängende Referenz stimmt mich wieder positiv, denn hier sind nach Programmiersprachen getrennt, die Funktionen zum Ansprechen der MySQL/mSQL-Datenbanken aufgelistet und mit kurzen Beispielen erläutert. Mein Tip daher: die Einführung in SQL lesen, dann anhand der Referenz weiterarbeiten. (Dies ist eine Amazon.de an der Uni-Studentenrezension.)
I disagree with many of the reviews I've read here."MySQL & mSQL" was EXACTLY what I hoped and expected it to be: a detailed discussion of what was unique to just those two database products. If you need to learn SQL, normalization, schema design, query optimiziation, etc, go buy one of the dozens of books already out there -- they apply to MySQL as well as Sybase, Oracle, etc.However, if you're like me and you already know SQL and relational database concepts, then all you really want to know is how MySQL/mSQL implement them and how you go about executing statements, running queries, and extracting results from your programming language of choice.I needed to know: what datatypes MySQL supports; what RDBMS features it does/does not provide, and how to get at them; how the peculiar MySQL security system operates; and how to access MySQL from Perl and Java. It answered every one of my questions comprehensively and succinctly.Exactly as it should have.
Before I start in with the thrashing, I would recomend this book to people who have NEVER done database development or administration. If you really haven't worked with databases this might be a nice, gentle intro. Otherwise, let the games begin.This book was a let down. It tried too hard to be all things to all people and ended up being nothing to nobody... The last 200+ pages of the book were a nice reference but that's about it. The begining of the book provided a nice history lesson and some background, but that information isn't that critical.If you are into Perl I would go through the MySQL tutorial that is part of the documentation If you develop in Python, Java, C++, PHP or some other language with a API for MySQL, maybe this is the best info available. I hope thats not the case.Better Luck Next Time...
This book covers everything revolving around MySQL except the engine itself and its supporting programs. It really should have stuck to documenting, in detail, how to use mysql, mysqladmin, mysqlaccess and how to use the APIs. Most everything was either a straight copy of the program help output or the MySQL documentation. It provided almost zero insights on using MySQL specifically. I understand more about the theory of MySQL permissions after reading this book, but I did not learn how to modify those permissions. They also completely missed an important point about auto-incrementing fields that I learned the hard way playing with MySQL. You are better off just reading the online documentation than buying this book. It's simply a waste of money.
I have significant experience building relational databases using MSql with C and Perl. I recently started working with MySQL with JDBC and Perl. The book has comprehensive chapters and appendix refrences covering all aspects of database administration and client access using Perl, Java, C, C++, and PHP. It is a great teching guide for the things that I don't know too well and a great reference to the things that I do. It is clear, concise and gives real-world examples. I purchased the Highes Technologies MSql book when it was first released - this O'Reilly book puts the Hughes book to shame. HIghly recommended, even for the experienced DB admin and programmer.
This book is a basic introduction to databases and administration, with a strong focus on Mysql and Msql. It does not go into deep details, but gives you a great overview on administration, database/table design and also writing programs that utilize Mysql and Msql. This book is a great along side with the Mysql manual, but should not be used as a standalone resource. If you remember you are buying a nutshell book, then you will not be disappointed.
This book has helped me learn the various ways to employ MySQL, but falls short as a reference. For example, from the PHP3 reference section you would think that PHP3 has no 'printf' function. The section on MySQL's security/privilege features attempts to explain how it works, but failed for me -- more examples would have helped. Unlike most other O'Reilly books that I use, this one does not have source code for the examples available on the Web.
I am new to DBs and programming. I was shocked to hit the "Reference" section on page 230-ish of a 430-ish book! What I needed was many concrete examples of Mysql practicalities, db and dba design under Mysql. Sure it is nice to have the extra references, but probably the book focused on the auxiliary topics too much. sorry O'Reilly, you're still awesome, i'm just a dummy who needs examples and breakdowns of examples. thanks.