Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

MySQL Paperback – Dec 22 1999


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback
"Please retry"
CDN$ 12.04 CDN$ 0.78

There is a newer edition of this item:

MySQL (5th Edition)
CDN$ 32.92
In Stock.

Summer Clearance on Books Books That Make You Think




July 15th is Prime Day

Product Details

  • Paperback: 800 pages
  • Publisher: Que Publishing; 1 edition (Dec 22 1999)
  • Language: English
  • ISBN-10: 0735709211
  • ISBN-13: 978-0735709218
  • Product Dimensions: 22.9 x 17.8 x 4.1 cm
  • Shipping Weight: 2 Kg
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (86 customer reviews)
  • Amazon Bestsellers Rank: #934,767 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From Amazon

The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn't "free" about MySQL (the application) is its server's commercial use; all clients and noncommercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its value and the value of its namesake.

The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)

The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces.

Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.

Although it is nearly 800 pages in length, DuBois's book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application. --Peter Leopold

From Library Journal

MySql is a very popular relational database for a number of reasons: it is free for most applications; while not open source it is heavily used by the open source community; and it runs easily on Windows and UNIX. The author's approach is to use two sample databases to explain SQL (structured query) databases with Perl, PHP, and C; administering MySql; and security. This book will be very popular with users who already understand relational databases and are trying to move from Microsoft or Oracle to MySql.
Copyright 2000 Reed Business Information, Inc.

Customer Reviews

4.7 out of 5 stars

Most helpful customer reviews

By Royal Tenenbaum on Jan. 13 2003
Format: Paperback
I bought this book some time ago as a php and mysql developer, to learn MySQL better. It is a very good book because the writer is also the programmer (lead programmer - he wrote the most of it) of MySQL. It contains what you'd expect it to contain: Both the theory and the solid code you'll need in many situations. It also explains uses of MySQL with other languages besides PHP and explains the API's pretty well.
It also has a section on managing MySQL on a webserver, how to backup properly, and MySQL security - not only for the programmer but for the system admin managing users and backups. It also contains a function reference appendix which, when properly used, is quite useful.
It is suitable as an intro level book as well, it DOES explain the basics and IS aimed for the beginner with zero knowledge. It will teach you MySQL but you might have to check some spesific tutorials online for spesific code you might want to use in projects - this book is not a cookbook, I don't think they intended it to be either. All in all, this book deserves its 5 stars - and keep handy Kevin Yank's hands-on applied tutorial to apply it to your projects.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I agree with other rave reviews: this is certainly the best technical book I have encountered, and it is a pleasure both to read through and to use as a reference. DuBois's style is clear and succinct, with a fine wit. Perhaps the most remarkable thing about this book is how much DuBois teaches within the confines of a single book -- so much, and so well presented, that the book seems far shorter than its physical thickness would suggest. By way of learning how to use MySQL for practical benefit, the reader also learns standard SQL, fundamental principles of database organization and management, and coding in C, Perl, and PHP, for use both on a local machine and in the Web context, not to mention installation and maintenance on various systems. The key to DuBois's clarity is his presentation of revealing examples at every step of the way, with explanations of each item. The index is also superb and there are richly helpful reference appendices.
(There is one error on p. 250, where DuBois leaves out the first argument to print_error(), the connection handle -- an easy enough mistake and one that I have made far too often since reading the book.)
If there were a prize for excellence in technical books, it should go to Paul DuBois. Bravo!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
The book MySQL is an excellent book. My employer uses MySQL for many of our database needs and, being relatively inexperienced with databases, I had to be brought up to speed quickly and with good, accurate knowledge. This book is that resource. The coverage includes everything from setting up databases and tables to new users and permissions. When I have a question I almost always go directly to the book as opposed to the help pages that came with the database itself. The clear wording and solid explanations along with the excellent examples make it an extremely handy reference to have around at all times. I find myself referring to the book quite often for the finer points in creating SQL statements to do what I need them to do. The examples in the book cover almost every situation I've needed them to. Very rarely do I have the need to go elsewhere or seek additional resources for an answer. If you are going to be developing applications that interact with a MySQL database (whether your language is Java, C, PHP, or PERL) you need this book. It covers all of the functions and common tasks as well as database administration, security, and maintenance and repair. This is a great book and I would highly recommend it to everyone working with MySQL databases.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
Most of the other MySQL books aren't really MySQL centered-they use it as the backend for a language (like PHP or perhaps it's a CGI book that has a chapter or two on dbs, and they use MySQL). This is the *definative* book on the db-the stamp of approval from the create mind behind MySQLAB (...) is on it.
This book has a little bit for everyone. If you wanted to just wet your appetite, you really don't need much more than the tutorial and the PHP chapter. With these two-you can pretty write a web-based app immediately.
Once you want to tune and optimize your application, you better check out the chapters that deal with the details of queries and indexing-the guts of the MySQL SQL. Also, the Perl chapter gives you a more robust language than PHP, and the C chapter gives you something if you want a blazing fast app.
Finally there are the administration chapters-they give you background on the admin tasks.
One suggestion I'd give though, make sure you read the MySQL docs. They're pretty good about details. Also, for PHP-get the PHP docs, the MySQL functions are really handy. If you want to use perl, get the Perl DBI book from O'reilly-I found it indispensable.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.
Format: Paperback
I read somewhere online that this book would be a great help to someone with no previous experience of mySQL - I have many years Unix experience and consider myself reasonably quick at picking up new skills yet I think this book was a waste of my money...
Before you can create a database you need to create a database account which aids data security. This was the area I stalled on because the book simply refers you to ask for assistance from your DBA... After more than half the way through the book it does spend some effort on creating access to your database for others though it does not say how you created access for yourself in the first place.
So - I have the book and no DBA meaning I have still to find another book to walk me through basic mySQL... I felt tricked and this book takes pride for being the first disappointment in my existing library of 50+ books covering Unix, Linux, Windoze, Networking and programming...
Saying all this though, I'm sure the book is a useful tool if you have some mySQL experience, but don't expect it to teach you how to run until you've learned how to walk elsewhere...
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most recent customer reviews



Feedback