Beginning Databases with MySQL

by Neil Matthew and Richard Stones

MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database.... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1861006926
• ISBN13: 9781861006929
• Release Date: February 2002
• Publisher: Wrox Press
• Length: 608 Pages
• Weight: 2.20 lbs.
• Dimensions: 1.2" x 7.3" x 9.0"

Customer Reviews

downloads gone

I found the book very useful, but a note of caution -The downloadable code supporting the examples in the book seems to have diappeared; saw some refs to the publisher going out of business. Gonna have to type in the code, but I can live with that.

Not exactly for beginners!

Many excellent books have been written about database design, SQL and applications such as Oracle, Mysql and Access. With a few exceptions, I've generally been pleased with the books on the subject, and this book is no exception.First, let me deal with the "beginning" in the title. It refers not to the proficiency of the intended reader but rather the book's tendency to start from square one and explain everything as if the reader knew absolutely nothing about mysql. Most books on this subject approach it in two ways: the systems approach (Chapter 1: Data Types, Chapter 2: Authentication, etc) and the tutorial approach (" First we need to install the program. Then we need to set up users and set up a simple database," etc). Although "systems" books usually prove more useful in the long run, tutorial books are easier to read and try to present a logical order in which to learn concepts. They generally have better examples and offer better strategies for performing elementary tasks. They also offer fuller explanations of the concepts and the mechanisms underlying an application or programming language. A good book can combine aspects of both types, but most books show a clear emphasis for one type over the other.Beginning Databases with Mysql did an excellent job at explaining what is happening under the hood during certain tasks. After reading the chapter on transactions and locking, I feel for the first time I really understood that very important subject. The book did a great job of explaining various scenarios and how mysql processes them. The book did a good job in pointing out common mistakes that DBA's make when writing queries or updating tables, as well as precautions to observe while loading new data (using a temporary load table for example). The book does a good job in conveying how to accomplish basic tasks and write queries efficiently.Beginning Databases with Mysql does spend time on advanced data selection. In addition to talking about union joins, outer joins and self-joins, as well as subqueries (and alternate ways that DBA's can accomplish these tasks even if Mysql doesn't support subqueries), the book stays abreast of what is changing in Mysql and talks about new developments, such as using Innodb tables for mysql transactions. I would have thought that a book like this would skimp on talking about administration and performance, but after reading the administration chapter, I've concluded that the information presented here is sufficient for my purposes. The book also contains some extra's, such as graphical Mysql GUI's in a Windows environment (which I had never seen before). Significantly, though, the book does NOT discuss myphpadmin, the most common web-based interface, which would have been nice. The book spends a chapter each on the mysql API's for Perl, Php, and C++ . I only skimmed through the chapters on Perl and C++, but the PHP chapter seemed confusing at parts and probably not sufficient for me (idiotprogrammer that

For Beginners but good

I wanted a book to get me workng with MySQL. This book was adequate and very quickly got me chugging mysql commands. Although not really administrative material, its good enough to get one familiarized with the essentials.Got some good looking tutorials and sample code to go with each one. Perfect book if you are a database newbie(the intro to databases could be invaluable) and need to manage a medium sized database with not too much traffic on it; hence the rating.

Excellent book for beginners

This book is ideal for MySQL beginners! If you want a great tutorial to get you familiarised with database concepts or if you are already a database expert and want to learn the ropes of MySQL quickly, this book is all you need. I had prior knowledge of Oracle and this book quickly got me upto speed with MySQL. It also has practical code examples on using MySQL from C and Java which were essential for my implementation. It contains examples on C++, PHP and Perl languages which cover most of the popular freeware spectrum. This book covers installation, configuration and a few other administration procedures on Unix and Windows platforms. My colleague who is new to databases, found that the material in chapters covering basic SQL, database transactions, locking, performance tuning etc alongwith the tutorials, got him to a point where he could administer a sizable MySQL database confidently...all in less than two days! The only downside is if you are using any Microsoft development tool, you will have to look into the online help of database to figure the details out. All in all, a great book and sits well on my techincal references shelf.

How do you access MySQL? Let me count the ways...

I've used a half dozen databases in ten years of academic and professional programming and there is no DB as cheap and easy to use as MySQL. Add connectivity to the web and it's dynamite! I like the fact that the authors cover MySQL installations for linux and windows. I'm really impressed with the sections on C, C++, PHP, perl, and java connectivity.It's a perfect resource for web developers who want their DB integration details in one compact book. For example, the book includes perl DBI/DBD installation instructions for both linux and windows OS's.However, this book lost a star by excluding ASP and VB connectivity (Is MySQL ODBC compliant? Is there an OLE-DB driver?) Improved editing in some sections will also make crucial information more visible. Regardless, this book is a valuable addition to my technical library.