HomeSite Help - The Bookstore

MySQL

skip navigation

We're moving!

This whole site is being moved to a shiny new server - as are all my sites, in fact. Apologies for the bumpy road ahead, but at the end of that road things will become fast and smooth.

Once the site at the new server is ready, this message will automatically disappear!

Meanwhile, you can see how the move is progressing at the status page.

 
skip navigation
Get notified when this page changes!
Let Spyonit.com notify you when this page changes!
Introduction
Finding other books
Titles:
 
 

Introduction


MySQL is one of the most frequently-used databases on the Web. The reasons are manifold, but given that it's free, and in many cases outperforms big-name (and expensive) commercial database systems this is not all that hard to understand. With PHP, which has native support for MySQL and many millions of installations, it forms a hard to beat combination which is provided by many hosting providers. Here you'll find my recommendations for books about MySQL.

 
cover
MySQL
(Amazon.co.uk)

by Paul DuBois
Textbook Binding - 756 pages 1st edition (December 28, 1999)
New Riders Publishing
ISBN: 0735709211

Background

If you're going to buy just a single book about MySQL, this is undoubtedly it. The author, daily answering user's questions on the MySQL mailing list, really knows what kind of questions and problems both beginning and advanced users have. I follow that mailing list daily, and if anyone asks for a book recommendation, this one invariably comes up. I'm using MySQL on this site, but I could do a lot more; so far, with experience in database design, I've muddled through, but I could use a lot more detailed knowledge on MySQL, and maintenance and administration in particular. High on my my wishlist!
Get it!

Robert Cross commented:

This seems to me to be the widely acknowledged best work on MySQL, and it covers the Windows 9X/NT versions of MySQL as well. Personally I regard it as a book to recommend without reservation, and my copy now looks a little battleworn!  to menu

 
cover
MySQL
(Amazon.co.uk)

by Michael Kofler
Paperback - 659 pages (June 2001)
APress
ISBN: 1893115577

Background

Michael Kofler takes a somewhat different approach than Paul Dubois in that it not only treats MySQL itself, but also how to build applications with it using PHP, Perl and ODBC. The book is also considerably newer making it possible to treat newer subjects such as transactions and full-text indices. The companion website has working examples, downloadable source code and databases, and other useful material and links. The choice between this book and Paul Bubois' will largely depend on whether you prefer more breadth or more depth.  to menu

 
cover
Mysql and Perl for the Web
(Amazon.co.uk)

by Paul DuBois
Paperback - 552 pages 1st edition (August 3, 2001)
New Riders Publishing
ISBN: 0735710546

Background

I use both Perl and MySQL a lot, but not in combination. If you do, you must have this book by one of the MySQL gurus.  to menu

 
cover
PHP Fast & Easy Web Development
(Amazon.co.uk)

by Julie C. Meloni
Paperback - 350 pages Bk&Cd-Rom edition (July 2000)
Premier Press, Inc.
ISBN: 076153055X

Another book to get started with PHP, and it covers the combination with MySQL as well. And once you've worked through this one, you may be ready for the PHP 4 Bible.  to menu

 
cover
PHP and MySQL Web Development
(Amazon.co.uk)

by Luke Welling, Laura Thomson
Paperback - 896 pages 1st edition (March 30, 2001)
Sams
ISBN: 0672317842

Background

 (In my library) Another book about the PHP/MySQL combo that doesn't assume too much and will take you quite a long way. But if you've grasped the basics already, this may not be what you are looking for. Then again, this books develops many practical real-world examples, including setting up an e-commerce site, user authentication, session control, etc. If you're looking for a kick start implementing such things yourself, the book may be exactly what you're looking for, even if you're no longer a beginner. The book has arrived now, and I'm absolutely delighted with it: each practical example is introduced with a clear outline of the problem and a nice diagram of the different states the solution should handle. Code modules that were developed earlier are sensibly re-used. It comes with a CD-Rom with everything you need to get started, and all sample code. If you use the combination of PHP and MySQL (or even PHP with another back-end database) this book can't be missed in your library.
Get it!

Bryan Capitano commented:

This is the best book on the market I think. But it depends on your skill level. This book has a section on basic PHP language, another section on setting up MySQL databases, and a third section with practical examples of PHP/MySQL projects, including source code etc.

It covers 90% of everything you'd need to REALLY know. For the other 10%, I like to use the WROX series Professional PHP Programming. It has a nice library of MySQL functions in the glossary which Welling and Thomson would have been really wise to incorporate.

The two of these books make a SLAMMING dynamic duo. You just can't fail with them.  to menu

 
 

Finding other books


You can use these search forms to search Amazon.com's or Amazon.co.uk's catalog for books, software, and more. And mail let me know what you missed so I can add it!

 to menu