mysql

Improvements to ROLLUP in MySQL ROLLUP has been supported in MySQL for sometime now. But until now its use has come with two implementation restrictions: it cannot be combined with DISTINCT or ORDER BY in the same query expression. Starting in 8.0.12, these limitations have been lifted.… Facebook Twitter Google+ LinkedIn Source: Improvements to ROLLUP in MySQL

MySQL User Camp, Bangalore – February 13th, 2019 At MySQL we love opportunities to interact with our users and MySQL User Camp gives us the chance to do just that. The first MySQL User Camp of this year was held on February 13th 2019 at the Oracle Kalyani Magnum Office.… Facebook Twitter Google+ LinkedIn Source: MySQL User Camp, Bangalore – February 13th, 2019

MySQL 8.0: New Storage Format for Compressed BLOBs In this article, let us look at the new storage format of compressed large objects (compressed LOB or ZLOB).  In my previous article MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates, I have explained about the new storage format of uncompressed LOBs. … Facebook Twitter Google+ LinkedIn Source: MySQL 8.0: New Storage Format for Compressed BLOBs

JSON specific window functions in MySQL 8.0 In 8.0, we introduced window functions in MySQL server. A detailed explanation of how window functions can be used and what is supported in 8.0 is explained here. Now, let’s see  what is new in window functions in the latest version 8.0.… Facebook Twitter Google+ LinkedIn Source: JSON specific window functions in MySQL 8.0