In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter. The principal MySQL developer, Monty Widenius, along with a network of his fellow developers, reviewed the manuscript, providing Paul with the kind of insight no one else could supply. Instead of merely giving you a general overview of MySQL, Paul teaches you how to make the most of its capabilities. Through two sample databases that run throughout the book, he gives you solutions to problems you'll likely face. He helps you integrate MySQL efficiently with third-party tools, such as PHP and Perl, enabling you to generate dynamic Web pages through database queries. He also teaches you to write programs that access MySQL databases.
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more. |
|
There is a newer edition of this item:
|
Book Description
Product details
Would you like to update product info or give feedback on images?
|
Product Description
Amazon Review
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organised 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-re-distributable 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 non-commercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its own and its namesake's value.
The volume is superbly organised in 12 chapters and 10 appendices and contains a concise table of contents and an expansive 50-page index for relational information extraction. It is peppered with references to the on-line HTML documentation that comes with the source and binary distributions (which are available and trivially-installable 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 Window 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 defence against common hacking strategies, the use of secure shell interfaces or access encryption.
Although it is nearly 800 pages, DuBois's book is gratefully not encyclopaedic. 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, Amazon.com
From the Back Cover
In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter. The principal MySQL developer, Monty Widenius, along with a network of his fellow developers, reviewed the manuscript, providing Paul with the kind of insight no one else could supply. Instead of merely giving you a general overview of MySQL, Paul teaches you how to make the most of its capabilities. Through two sample databases that run throughout the book, he gives you solutions to problems youll likely face. He helps you integrate MySQL efficiently with third-party tools, such as PHP and Perl, enabling you to generate dynamic Web pages through database queries. He also teaches you to write programs that access MySQL databases.
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
14 of 15 people found the following review helpful
By A Customer
I found myself having to use MySQL to backend a C-based project I was doing, but I'd not seen MySQL before. Used this book along with the online manual and had the application working great (with replication!) in about three days. Just added a web-based PHP front end too. All this is documented in this book, very clear and easy to follow. Problems? - if you don't know SQL, get a SQL reference as well, and the book is a bit out of date, which is normal with computer software books. Oh, and it's a bit on the pricy side.. Summary: in my opinion this book is as definitive on MySQL as K&R is/was on the C language. Get it!
2 of 2 people found the following review helpful
By A Customer
This book is one of the most complete book on MySQL. I wish I had it earlier before buying O'Reilly's mSQL/MySQL. Although O'Reilly's is good (with quite a lot of errata) overview of mSQL and MySQL, this book covers MySQL in more details, down to some scripts/tips that you can use while writing your SQL statements. Optimizing your query is also mentioned, plus interfacing MySQL with C, Perl and Php (why no Java?).
If you want a good book on MySQL, this is the one.
1 of 1 people found the following review helpful
By A Customer
A clear insight into MySql. Saved me having to print out the online documentation
Would you like to see more reviews about this item?
›
Go to Amazon.com to see all 82 reviews
4.7 out of 5 stars
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
5.0 out of 5 stars
An excellent book - probably the only MySQL book needed
Having embarked up on a large project for my Company, utilising both PHP and MySQL I found this book a godsend. Read more
Published on 7 Mar 2001
4.0 out of 5 stars
Great book for first timers for MySQL
This book is cool, I mean it is great if this is your first time programming this cool open source relational database. Though I recommend mixing PHP with MySQL! Read more
Published on 10 Nov 2000
4.0 out of 5 stars
V good with qualifications.
A good reference, I just found that I am continually going to the PHP section of the book (alas less than 50 of its 700 pages), and that the SQL syntax could do with being easier... Read more
Published on 23 Aug 2000 by William Owen Smith
5.0 out of 5 stars
Truly excellent
This is a truly excellent book on MySQL, it covers almost everything one ever needs to know about the Open Source database program. Read more
Published on 4 Aug 2000
5.0 out of 5 stars
One of the best!
A very consise and complete book! Being a complete beginner when I first bought it, I would definitely recommend it to anyone.
Published on 18 July 2000 by jon@vort-x.com
5.0 out of 5 stars
The best book available of the subject of MySQL
Paul, I would truely like to congratulate you on such complete and comprehensive coverage of MySQL. For people who don't know Paul is a frequent contributor to both the support... Read more
Published on 27 Jun 2000 by "baadjim"
Customer Discussions
|
This product's forum
Search Customer Discussions
|
Related forums
|
![[Start the discussion]](http://g-ecx.images-amazon.com/images/G/02/x-locale/communities/discussion_boards/start-new-discussion-sec._V192198663_.gif){kind=small}
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > MySQL > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > MySQL > Introduction
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > UNIX & Linux
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
