Fun MySQL fact of the day: table pullouts

As noted yesterday, MySQL 5.6 was released with a large number of optimisations to the subquery engine. In particular, a number of changes were made to optimise for non-scalar, uncorrelated subqueries, allowing them to be run as... you guess it! Joins. ... read more

Fun MySQL fact of the day: subqueries in MySQL5.5

The year 2013 can be remembered by 3 separate things: Justin Timberlake, the series finale of Breaking Bad, and the release of MySQL 5.6. Though, if you aren't a MySQL historian, the release of MySQL 5.6 may have passed you by and you may have missed the ... read more
1 2 3 4 5 6 7