MySQL 5.7 provides a JSON data type. Previously you could store JSON formatted data in some sort of text field but then you would have to use REGEX which would reduce the quality of your work life, make your grumpy, and would be frustrated when you had to maintain it. Now you have over two dozen functions, can create materialized columns from JSON data that can be indexed for fast searchers, and can output data in JSON. This is a quick introduction for PHP developers to learn to incorporate this new data type with plenty of programming examples.


Comments are closed.

John Fansler at 15:16 on 24 Oct 2017

Good overview of these new features - I look forward to trying generated columns and getting more into the JSON functions!

Great to have a look at the power of JSON with Mysql, and some new features coming in 8.0... Bash completion!!!

Alex Vinot at 08:34 on 26 Oct 2017

good stuff

Jason Davis at 12:34 on 31 Oct 2017

Loved seeing examples