5.0 went into production in autumn 2005. Get It Done covers all 5.0 releases.
The 5.1 series has been in production since autumn 2008. Upgrades with third-party plugin database engines have appeared. Get It Done covers all 5.1 releases.
Early in 2009 MySQL introduced the 5.4-5.5-5.6 release series. 5.4 was soon replaced by 5.5. New features include scalability improvements, a new INNODB engine, proxy logins, and features backported from the 6.0 series including SIGNAL and RESIGNAL error messaging. It has been stable and in production since December 2010.
5.6, now in production, adds crash-safe binary logs; SQL partition support; UUIDs for each server instance; delayed and multi-thread replication; row image control in replication; performance_schema enhancements; better optimisation of JOIN, WHERE and LIMIT clauses; better information_schema InnoDB metadata; microsecond support in columns that store time; and much needed, much improved error info retrieval with the new GET DIAGNOSTICS command.
5.7 appeared as a development release in April 2013, and went into general release in late 2015. It offers improved security, logging and Triggers; it supports subqueries in Views, JSON columns and indexable derived columns in tables; and fixes many 5.5 and 5.6 bugs.
8.0 appeared as development release 8.0.0 in September 2016. It has been in generally availability since spring 2018. It expands regex (long overdue), improves InnoDB, and moves system tables and the global data dictionary to it; revises partitioning; adds persistent global variables; adds binary strings to bit function scope; improves query parsing and index use; and adds component-based infrastructure, SQL roles, a utf8mbr collation. Recursion-capable Common Table Expressions are implemented (they were already in MariaDB 10.2.2); Chapter 20 of Get It Done has examples. There is also support for OVER() and Windowing/Analytic functions.
For some time, the MySQL development team had referred to the next major release after 5.7 as 5.8. The release of 8.0 confirms that there'll not be another MySQL 6.0, so we updated the name of Get It Done to Get It Done With MySQL 5&Up.
Get It Done covers all 5.0, 5.1, 5.4, 5.5, 5.6, 5.7, 8.0 releases, also features from the abandoned version 6.0 that haven't yet been ported to currently active MySQL releases.
We've also put up links to the MySQL Server Developmnt Team's development notes on new featuress in 8.0 under "Version Notes" on our Tips page.
"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&Up" 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
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 databases, one for SQL Server 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.