mysql

Connector/ODBC 5.3 Connector/ODBC 5.3 (5.3.6 GA, published on Thursday, 17 Mar 2016) Source: Connector/ODBC 5.3

Upgrading JSON data stored in TEXT columns One of the more frequently asked questions with MySQL 5.7 is “How can I upgrade my JSON data from using TEXT in an earlier version of MySQL to use the native JSON data type?”. Today I wanted to show an example of how to do so, using sample data from SF OpenData.… Source: Upgrading JSON data stored in TEXT columns

Indexing JSON documents via Virtual Columns In a previous post I took the new JSON datatype and functions for a test drive, using sample data provided by SF OpenData. Today I will extend that example to include indexing. Introducing Generated Columns MySQL 5.7 introduces a new feature called generated columns.… Source: Indexing JSON documents via Virtual Columns

MySQL Router 2.0 MySQL Router 2.0 (2.0.3 GA, published on Thursday, 03 Mar 2016) Source: MySQL Router 2.0

Taking the new MySQL 5.7 JSON features for a test drive MySQL 5.7 introduces both a new native JSON datatype, and a set of SQL functions to be able to manipulate and search data in a very natural way on the server-side. Today I wanted to show a simple of example of these features in action using sample data from SF OpenData.… Source: Taking the new MySQL 5.7 JSON features for a test drive