| Current editions
The first production release of MySQL 5.0 was 5.0.15 in autumn 2005.
The current production version for the freely downloadable 5.0 Community Edition is 5.0.90.
The current edition of Get It Done covers all 5.0 releases through 5.0.90.
The 5.1 series has been in production since autumn 2008, the most recent freely downloadable release being 5.1.43. 5.1 builds with third-party plugin database engines have appeared, and more are expected. The current edition of Get It Done covers all 5.1 releases through 5.1.43. In April 2009 MySQL introduiced the 5.4/5.5 series of releases with 5.4.0. In this series, MySQL abandons alpha, beta and gamma release labels in favour of milestones. 5.5.1-m2 (milestone 2) delivers scalability improvements including a new built-in INNODB engine, and other features backported from the 6.0 series including SIGNAL and RESIGNAL error message handlers. The current edition of Get It Done covers all 5.4/5.5 releases through 5.5.1-m2. |
Reviews, feedback
"This is, without a doubt, the best of all the books on MySQL I've found." -- Phil Mickelson "timely, relevant, and correct ... also well organized and quite complete" -- Baron Schwartz "Looks like the book to get if you are a MySQL programmer." -- Jim Lawrence "A complete MySQL resource." -- Diego Medina "Your website "Get it Done with MySQL 5&6" is simply awesome and thank you again." -- Balaji Thiayagarajan "*Splutter*, *gasp*--YES! How the heck did you do that? It worked like a charm first try. Wonderful, sir--you just tell me where to send the baked ham, and it's yours." -- Max Loeb |
| Buy It Now! Click here to buy your copy of Get It Done With MySQL 5&6. Buy the ebook with updates and get free updates for three years. Buy the print edition to get a handsome book, plus the ebook, plus three years of updates. Buy the ebook by itself and get a month of free updates. | Advanced Topics
Working with Graphs in MySQL
shows how to implement edge-adjacency list and nested sets graph models of family trees,
plane routes and parts explosions, including working queries and stored procedures, 34 code listings in all.
Who Knows Where The Time Goes? is a full account of how to implement time validity and point-in-time architecture using MySQL 5, with 70 working SQL scripts. Visual Studio 2005 and MySQL is an 80-page walkthrough with analysis, explanation and source code for two perfectly general and complete standalone .NET 2.0 versions of a Windows database-enabled application, one for MySQL 5 databases, and one for SQL Server 2005 databases. Runtime ComboBox selection of database and tables, master-detail grids, just-in-time on-the-fly DataGridView lookup browse windows, general-purpose Find dialogs, a ListView lookup browser, and more. |
| Try it
Browse the sample chapters from the links down the left side of this page. For more samples of our take on MySQL, see the Common Queries and MySQL Tips pages. |
Common queries Our collection of common MySQL queries soon outgrew Chapter 9. It runs now to more than 120 printed pages, and it's still growing, so we turned it into a PHP page driven by a pair of MySQL tables implementing an edge list tree model (for how to use edge list and other tree models in MySQL, see Chapter 20 of the book). Click here for the Common Queries page, and here for a panelled tree view of the same material. |
Much of the world's data lives in MySQL databases...
If you work with some of that data, give your excellent brain a treat with ...
... full, readable accounts of how to use MySQL versions 5.0.0 through 5.0.90, 5.1.0 through 5.1.43, the new and optimised version 5.5, and in case you're working with the temporarily withdrawn 6.0, that too,
... full accounts of MySQL installation, configuration, data types, storage engines, syntax, privilege management, query building, stored routines, administrative utilities, and security,
... clear step-by-step chapters to get you started using MySQL with ODBC, Perl, PHP, Java, Visual Studio and C/C++,
... a concise account of how to use the high-performance new INNODB engine for MySQL 5.1 and 5.5, so you can configure it and fire it up without having to wade through its 88 pages of documentation,
... clear, enjoyable chapters on database theory, how to design a database, and the database application life cycle,
... in-depth treatments of trees and other hierarchies, point-in-time architecture, and MySQL with Visual Studio 2005.
... lookup cheat sheets for MySQL configuration variables and information_schema,
... clear coverage of Sun/MySQL's temporary withdrawal of MySQL version 6.0, the introduction of MySQL versions 5..4/5.5, and of features that have been backported from 6.0 to 5.5.
Why MySQL?
How many relational database management systems are robust and full-featured enough to bet your enterprise on? A half-dozen? How many of them can you download for full and free use on Windows, *Nix, a Mac, Solaris, or IBM AIX or i5? One: MySQL Community Edition.
Before MySQL 4.1, some scoffed at the product. No subqueries, no stored procedures, no views, no triggers. Forget that. Subqueries came in with version 4.1. 5.0 brought stored procedures and functions, views, triggers, XA transactions, a cluster engine, and a full-fledged information schema. MySQL 5.1 added an Event Scheduler. 5.5 adds error message handling, XML processing and semisynchronous replication. There are a stable 5.0 and 5.1 production releases.
From a small-footprint database system aimed at web developers, to a full-featured, sophisticated, standards-based, ever-improving RDBMS, in just a few years. Free for your customers to use too, if you you don't distribute your databases with proprietary code.
Each chapter saves you time ...
... with efficient design ideas, quick info lookups, examples you can put to work.
The first time the SQL Command Syntax chapter saves you 20-30 minutes looking for a bit of syntax you forgot or never knew, the book pays for itself.
The first time an API chapter saves you 20-30 minutes with a clear explanation of how to do something in C or Perl or PHP or Java or .NET or ODBC, the book pays for itself again, perhaps several times over.
The first time the Configuration Variables Appendix saves you 20-30 minutes searching for info on one of MySQL's more than 500 configuration settings, the book pays for itself yet again.
The first time you copy the VirtualMode DataGridView from Chapter 22 straight into a .NET app of yours, the book pays for itself about twenty times over. Ditto for the first time you crib a tree traversal routine from Chapter 20, or a point-in-time design from Chapter 21.
Do yourself a favour, buy it now:
- $18.95 US for the ebook,
- $27.95 US for the ebook plus three years of updates,
- $49.95 US for the print edition, plus the ebook, plus three years of ebook updates.
Keep yourself up to date
When did you last buy a book whose most recent material was just days or weeks old? Get It Done With MySQL 5&6 is always that current. Thanks to print-on-demand technology, that's true not just for the ebook; it's true for the print edition too.
Why is that important? MySQL puts out frequent revisions. Our turnaround time for many releases is a few days. From the edition for 5.0.1 to current editions, covering all releases in the MySQL 5.0, 5.1 and 5.4 series, our content has grown by 40%. If you had an update subscription, you got all this new information right after each MySQL release—for one low price.