In this post we will use the MySQL 5.7.7 labs release which has support for JSON documents stored in a special data type. We will be using Connector/Python and show how to get going with updating documents and getting data out.
If you wonder what this is all about, please check the following great reads from the MySQL Server team:
- JSON Labs Release: Native JSON Data Type and Binary Format
- JSON Labs Release: JSON Functions, Part 2 — Querying …