Current editions
There are freely downloadable community editions for MySQL 5.0,
5.1, 5.5 and 5.6.
|
Reviews, feedback
"Timely, relevant, and correct ... also well organized
and quite complete" -- Baron Schwartz "This is, without a doubt, the best of all the books on MySQL I've found." -- Phil Mickelson "Excellent book." -- Michael K. Peterson "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 |
|
Advanced Topics
Working with Graphs in MySQL shows
how to implement edge list, nested
sets, and hybrid models of hierarchies like family
trees, plane routes and parts
explosions. There are more than 40 working
queries and routines, including a PHP function which renders
any tree graphically using the new Google Visualization API. 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 and MySQL is an 80-page walkthrough with analysis, explanation and source code for two perfectly general and complete standalone .NET 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&6.
Buy the ebook with updates and get free
updates for five years. Buy the print edition
to get a handsome book, plus the ebook, plus five
years of updates. Buy the ebook by itself and get a
month of free updates. 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. |
| TheUsual A free, fast, user-friendly web browser interface, written in PHP, for all your MySQL databases on all your servers, whether you own the servers your databases are on, rent them, or share hosting services. Supports automatic queries, ad hoc and saved queries, automatic master-detail browsing, pagination and sorting, add/edit/copy/delete table maintenance, stored routine creation & maintenance, database maintenance & backup, and on-the-fly Area, Motion, Org/Tree, Pie and Scatter graphical charts. | Common queries Our collection of common MySQL queries soon outgrew Chapter 9. It runs now to more than 120 printed pages, and it is 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. |
If you work with MySQL ...
Weightless ebooks simplify your life! Give that excellent brain of yours a treat with ...
... readable accounts of how to use MySQL versions 5.0, 5.1, 5.5, 5.6, 5.7 and in case you still have an instance of (the withdrawn) version 6.0 running, that too,
... concise accounts of new MySQL features,
... clear accounts of MySQL installation, configuration, data types, storage engines, syntax, privilege management, query building, stored routines, administrative utilities, and security,
... 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, so you can configure it and fire it up without having to wade through its 88 pages of documentation,
... 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,
... a history of MySQL from its inception through its successive purchases by Sun and Oracle.
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 information schema. MySQL 5.1 added an Event Scheduler. 5.5 added error message handling, proxy logins, XML processing and semisynchronous replication. 5.6 adds crash-safe binary logs; partition options in SQL commands, delayed replication, and (finally!) better LIMIT optimisation. 5.0 has been retired. There are stable 5.1, 5.5 and 5.6 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 do not 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 the more than 500 MySQL 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 five years of updates,
- $49.95 US for the print edition, plus the ebook, plus five years of ebook updates.
Keep yourself up to date
Dead-tree publishing gives you a 500-1000 page tome. It's months or years old. Maybe 200 pages are relevant to you. Some are out of date by the time you read them. So you lug home this two-kilogram object, read the pages of interest, curse the out-of-dateness, and ignore the rest.
Trees died, trucks lugged heavy pallets of books to bookstores, more CO2 made your summer hotter, and you weren't all that satisfied.
It's time to give that 19th century idea of publishing a rest. Some chapters of this book are free. You can purchase the whole book as an inexpensive weightless download, with an optional five-year subscription for updates. Why isn't it on a Kindle or an iPad? We want you, not Amazon or Apple, to own your copy, and we want you to update it as often as you like.
And if you want the nicely printed and bound physical book, our printing is on-demand so your book was printed a few days ago instead of a few years ago, and you still get the electronic edition and updates too.