Get It Done With MySQL, Artful Software Development, Artful applications

Much of the world's data lives in MySQL ...

If you work with some of it, give that excellent brain of yours a treat with ...

... full, readable accounts of how to use MySQL versions 5.0.0 through 5.0.83, 5.1.0 through 5.1.35 , 5.4, and 6.0.0 through 6.0.11,

... enlightening, enjoyable chapters on database theory, how to design a database, and the database application life cycle,

... 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++,

... in-depth treatments of trees and other hierarchies, point-in-time architecture, and MySQL with Visual Studio 2005.

... lookup tables for all MySQL configuration variables and all of MySQL's information_schema.

Get yourself an ebook edition for your laptop, and a print edition for your lap.

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. No query nesting, 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. There is a stable production 5.0 release. MySQL 5.1, now a release candidate build, has added an Event Scheduler. 6.0 has added a new ACID-compliant database engine and another new crash-resistant storage engine.

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 Chapter 21.

Do yourself a favour, buy it now:

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 6.0 series, our content grew by 40%. If you had an update subscription, you got all this new information right after each MySQL release—for one low price.

Current editions The first production release of MySQL 5 was 5.0.15. The current production version for the freely downloadable 5.0 Community Edition is 5.0.83. The 5.1 series is also in production, the most recent release being 5.1.35. Builds with third-party plugin database engines have appeared, and more are expected. Alpha releases of the 6.0 series have reached 6.0.11, incorporating much-needed query optimisations; improvements in error handling; early versions of the new high-performance Falcon database engine; and starting with 6.0.7, the new Maria database engine, which is mainly MyISAM with automatic crash recovery, a boon for projects where InnoDB cannot be used. Get It Done With MySQL 5&6 covers all freely downloadable Community Edition 5.0, 5.1, 5.4 and 6.0 MySQL releases. We publish a new edition whenever MySQL puts out a new 5.0, 5.1, 5.4 or 6.0 release. And if you are working short of the bleeding edge, you can download editions of the book going back more than a year.	Advanced Topics The newest Advanced Topic is Visual Studio 2005 and MySQL, 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. Other advanced topics are Working with Graphs in MySQL, shows how to implement edge-adjacency list and nested sets graph models of family trees, aeroplane routes and parts explosions, including working queries and stored procedures, 34 code listings in all, and Who Knows Where The Time Goes?, a full account of how to implement time validity and point-in-time architecture using MySQL 5, with 70 working SQL scripts.
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 two years. Buy the print edition and get that plus the ebook plus the updates. Buy the ebook by itself and get a month of free updates.	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.
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.	Feedback "Your website "Get it Done with MySQL 5&6" is simply awesome and thank you again." -- Balaji Thiayagarajan "A complete MySQL resource." -- Diego Medina "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 "Looks like the book to get if you are a MySQL programmer." -- Jim Lawrence