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

First MySQL 5.0, then 5.1, now 6.0...

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 to use so long as you you don't distribute your databases with proprietary code. Those are a few of the reasons ...

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.51a, 5.1.0 through 5.1.25, and 6.0.0 through 6.0.5,

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

You can have an ebook edition for your laptop, and a print edition for your lap.

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.

The current edition covers MySQL 5.0 up to version 5.0.51a (production), 5.1 up to 5.1.25, and 6.0 up to 6.0.5.

Do yourself a favour, buy it now:

Why MySQL?

The list of relational database management systems that are full-featured enough, and robust enough, to bet your company on, whatever its size. is pretty short. Five or six at most. Those that can be downloaded free make a list of one item. MySQL is it.

We don't own shares in MySQL AB. We just notice what owners of about two-thirds of the world's database-driven websites notice.

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.

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.

Why is that important? MySQL AB often puts out 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 is 5.0.51a. The 5.1 series reached the release candidate stage with 5.1.22, and is now at 5.1.26. A 5.1 build incorporating the new PBXT third-party database engine has appeared, and more are expected. Several alpha releases of 6.0 have already appeared, incorporating preliminary versions of the new Falcon database engine and, starting with 6.0.6, the new Maria database engine, which is essentially MyISAM with automatic crash recovery, a boon for projects where InnoDB is not a possibility. Get It Done With MySQL 5&6 covers all Community Edition 5.0, 5,1 and 6.0 MySQL releases. We publish a new edition whenever MySQL puts out a new 5.0, 5.1 or 6.0 release. And if you are working short of the bleeding edge, editions of the book going back a year or more are available to you.	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 outgrew Chapter 9, and is still growing, so we turned it into a PHP page driven from a MySQL table. Click here.
Try it Browse and study the sample chapters from the links at the left of this page.