Managing and Using MySQL
July 18th, 2010 by CGI & PHP.com
Product Description
MySQL is a popular open source database product that supports key subsets of SQL on Linux and Unix systems. If you want to build database-backed web pages or other database applications, Managing & Using MySQL, 2nd Edition has everything you need to get started. It takes you through the whole process from installation and configuration to programming interfaces and database administration. Also included is an introduction to SQL and to relational databases. … More >>
Popularity: 4% [?]
Sams Teach Yourself MySQL in 10 Minutes
Effortless E-Commerce with PHP and MySQL
Perl & LWP
Perl for Oracle Dbas
Functional Programming for Java Developers: Tools for Better Concurrency, Abstraction, and Agility
MySQL Administrator's Guide
July 18th, 2010 at 7:53 am
this is a typical book comes out of George Reese:
1. poorly written
2. shamelessly copy and paste existing materials from reference manual
3. full of error
the author is only trying to get a quick buck or two.avoid it at all cost.
Rating: 1 / 5
July 18th, 2010 at 10:31 am
The book helps one to program for MYSQL in C, or other languages for that matter, but the installation section does not describe how to set up the "my.ini" file. It does a good job on the SQL syntax used by MySQL.
Rating: 4 / 5
July 18th, 2010 at 11:26 am
If you are buying this book to learn how to manage MYSQL look on.. There is maybe one chapter on server mgt.. and 20 on programming for mysql.
The server mgt. they do have is not very good, you would be better suited getting the docs from mysql.org.
Jeremy
Rating: 3 / 5
July 18th, 2010 at 12:16 pm
This book is a significant improvement over the 1st edition (which was titled MySQL & mSQL), mainly because it focuses directly on MySQL instead of focusing on the differences between MySQL and mSQL. This book leaves out critical information, which is why I gave it only 2 stars. The word REPLICATION isn't even in the book's Index (I skimmed the book and didn't see it covered anywhere in the text either), and MySQL's Replication Functionality is one of its most valuable features for fault tolerance! Also, the book is ambiguous on other Fault Tolerance issues. For example, on page 74 the book says to "store the binary logs on the same device as the backups". Binary logs are generated real-time as incremental updates between the nightly dumps – the book makes no effort to explain how to replicate those logs real-time to a separate server. If you're going to buy only one book on MySQL, I'd suggest Atkinson's book: core MySQL.
Rating: 2 / 5
July 18th, 2010 at 2:28 pm
This book was excellent for my need: I had used SQL before but didn't know much of anything about relational databases let alone MySQL. I am in the process of building a web application that reports survey data. It will tell you everything you need to know to get started with a small to mid-size database.
Best of all, this book is well written, clear, the examples are GREAT and if you cut out the portions that are not relevant to you (for me this was security and the sections on PHP and Perl to name a few) you can literally learn all you need to know to get started in less than two weeks of studying for a few hours per day. Amazing value.
The portions of the book on MySQL itself are not obviously dated, but the Python DB API interface has changed (to version 2.0) since this book was written.
Rating: 5 / 5