All posts by Evgeny Potemkin

Inline JSON Path Expressions in MySQL 5.7

October 27, 2015JSON, MySQL, Parser, SyntaxEvgeny Potemkin

MySQL 5.7.9 has a new feature, that simplifies queries that deal with JSON data and makes more human-readable: inlined JSON path expressions. Now you can do following:

mysql> CREATE TABLE employees (data JSON);
Query OK, 0 rows affected (0,01 sec)

mysql> INSERT INTO employees VALUES ('{"id": 1, "name": "Jane"}');
Query OK, 1 row affected (0,00 sec)

mysql> INSERT INTO employees VALUES ('{"id": 2, "name": "Joe"}');
Query OK, 1 row affected (0,00 sec)

mysql> SELECT * FROM employees WHERE data->'$.id'=

…

Generated Columns in MySQL 5.7.5

October 3, 2014MySQL, OptimizerEvgeny Potemkin

Generated Columns is a new feature available in the latest lab release. This work is based on a contribution by Andrey Zhakov. Thanks, Andrey! The Optimizer team modified it to follow the current MySQL design, and to lift a number of limitations.…

MySQL Server Blog

News from the MySQL Server Team

All posts by Evgeny Potemkin

Inline JSON Path Expressions in MySQL 5.7

Generated Columns in MySQL 5.7.5