- Series: Definitive Guides (Paperback)
- Paperback: 784 pages
- Publisher: Apress; 3rd Corrected ed., Corr. 2nd printing edition (October 3, 2005)
- Language: English
- ISBN-10: 1590595351
- ISBN-13: 978-1590595350
- Product Dimensions: 7 x 1.8 x 9.2 inches
- Shipping Weight: 2.7 pounds (View shipping rates and policies)
- Average Customer Review: 3.3 out of 5 stars See all reviews (21 customer reviews)
- Amazon Best Sellers Rank: #321,558 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
The Definitive Guide to MySQL 5 (Definitive Guides (Paperback)) Paperback – October 3, 2005
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who viewed this item also viewed
About the Author
Michael Kofler holds a Ph.D. in computer science from Graz Technical University in Austria. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.
If you are a seller for this product, would you like to suggest updates through seller support?
Top Customer Reviews
I find it hard to find a good SQL resource guide/book. So this looked like a good purchase.
I just thumbed through the first example in chapter 3. It looks like there is some errors in the PHP code which one reviewer has mentioned and it does not give me a good feeling. The examples should be correct and if they are not then the book should have not been published or an errata guide needs to be available from the publisher.
For example the PHP opinion poll example...
1) The use of choice is misleading... One place it looks correct but only in one place.
2) The function does not look like it is being used and I do not think it is used. Where is the function call? I do not know why he includes this on a first example anyway; there is no need for it...
3) The most striking error is the choice array which I believe should be choicetext since he creates an array with the variable but choice is just the index.
On a side note, I believe coding this in PERL is much easier than PHP. I am not as familiar with PHP, but is it apparent when something does not look correct.
I think I may contact the author if possible before considering returning this book.
Probably too much for a pure beginner, but like many of my aPress books - it will be a constant reference. And the $10 eBook purchase means that I have a mobile friendly version while I travel.
Worth the price; well written and structured. Probably too simple for intermediate level people who are close to becoming experts, but the original reviews were accurate and credible.
"In order to generate a table with the two columns /id/ and /choice/, the following command would suffice: CREATE TABLE votelanguage (id INT, choice TINYINT, ts TIMESTAMP);". If you are new to MySQL, you may be wondering about "ts TIMESTAMP".
At every page I have turned to and begun to read, I have found at least one similarly minor/distracting error: "changes in boldface" followed by lines of code with no boldface, "the following will insert a data record with a value of 4: INSERT into t VALUES (3)", etc, etc, etc...
There are numerous sections of text that are terribly written, almost as though they have been badly translated from another language. Chapter 4, for instance, opens with "The end user should never see MySQL as a program. Instead, a convenient program or several web sites should be used to provide access to the database, assist in the input of new data and execute backups
"For such tasks, you can use the commands mysql, mysqladmin and mysqldump ...". Presumably he mean't that these commands are not the interface through which the typical user will see MySQL.
I said the book is not definitive - I say this because its focus is incredibly broad. It covers a wide spectrum of MySQL-related topics, primarily dealing with specifics of language interfaces (by sheer volume of pages). It covers nothing in true depth (with several item specific chapters containing the "Tip" that "In this chapter you will learn about /this/ only superficially. However, ... will be described elsewhere in the book ..."
Every time I open this book, I find errors or cryptic paragraphs that I have to deconstruct in order to understand the author's point. Often times, even when the author is quite clear, I find his points to be in error. For example, returning to the initial opinion poll: the author implies that if your result set were merely the vote option and number of votes for that option, it would be simplest to just store that in a single file. But if you wanted to store individual votes or comments or IP addresses, you would need MySQL!
Infact, due to concurrency issues, MySQL would be far better suited to the simple tally counter.
In general, I found this book a hard read. It's very dry and in my opinion, not well laid out. This book is for someone who already has foundational knowledge in MySQL and some programming. The author seems to have a thorough understanding of the topic, but is not good at teaching to underlings such as myself. I'm not going to toss the book, but keep it on my shelf as a reference. In the mean time I need to find another book on MySQL.
Most Recent Customer Reviews
If you're completely new to SQL, this doesn't give you good SQL basics.Read more