The MySQL Document Store functionality allows developers to use a relation database with or without SQL (structured Query Language), also known as NoSQL. The example in this blog is hopefully a simple look at this new feature of MySQL. The example data used is from JSONStudio.com and is a JSON formatted data set for US zip (postal) codes (656K compressed). So download your copy of this data set and lets get to work.
Create a collectionCollections are tables and below we create a collection name 'zip' in the test database in the Python dialect.
mysqlsh -u root -p --py test
Creating an X Session to root@localhost:33060/test
Default schema `test` accessible through db.
Welcome to MySQL Shell 1.0.4 Development Preview
Copyright (c) 2016, Oracle and/or its affiliates. …