|
Current editions The first production release of MySQL 5 was 5.0.15. The current production version for 5.0 is 5.0.51a. The 5.1 series reached the release candidate stage with 5.1.22, and is now at 5.1.23. A 5.1 build incorporating the new PBXT third-party database engine has appeared, and more are expected. Early alpha releases of 6.0 have also appeared, incorporating preliminary versions of the new Falcon database engine. Get It Done With MySQL 5 covers all 5.0 and 5.1 releases and includes notes on MySQL 6.0. Our current print and electronic editions are for 5.0.51a and 5.1.23-RC. If you prefer to do your database work with a release that is a bit short of the bleeding edge, you can choose electronic editions of Get It Done With MySQL 5 dating back a year or more. |
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. |
| Buy It Now! Click here to buy your copy of Get It Done With MySQL 5. Buy the ebook with updates and get free updates for a year. 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. |
| Next editions Update releases in the MySQL 5.0 and 5.1 series appeared about once a month in the first two years or so of the version 5 release cycle. Now that 5.0 has reached stability and 5.1 is approaching a production release, releases are less frequent. Whatever their frequency, within a few days of each release we publish an update to Get It Done. |
Future editions The most anticipated MySQL developments are general-purpose foreign key management and a fully implemented ACID-compliant high-concurrency Falcon engine. Both are expected in the 6.0 release cycle. When these 6.0 developments become usable, our book will become Get It Done With MySQL 5 and 6. |
| Database links If you own, or manage, or simply know of a good online database information or tutorial site, please send us the link. We'll be happy to add it to our lists. |
Try it Browse and study the sample chapters from the links at the left of this page. |
We are what we read ...
So if you use MySQL, give that excellent brain of yours a treat ...
... full, readable accounts of how to manage data with the newest version of MySQL,
... 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 inexpensive ebook edition for your desktop, and/or 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 of the book covers MySQL 5.0 up to version 5.0.51a (production), and MySQL 5.1 up to 5.1.23 (release candidate).
Do yourself a favour, buy it now:
- $18.95 US for the ebook,
- $27.95 US for the ebook plus a full year of updates,
- $59.95 US for the print edition, plus the ebook, plus a full year of ebook updates.
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. And MySQL 5.1, now published as a release candidate build, has added an Event Scheduler.
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 is always that current.
Why is that important? MySQL AB often puts out revisions. Our turnaround time for most releases is a few days. From the edition for 5.0.1 to current editions, covering all releases in the MySQL 5.0 and 5.1 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.