Last time we looked at moving a JSON data set from MongoDB to the
MySQL Document Store. Let's move another and then see how
to investigate this date. We will use the
primer-dataset.json that contains data on restaurants around New
The loading of the JSON data set was covered last time but here is the gist. The first step is to fire up the MySQL Shell and login to the server.
|Here a new schema is created and then a new collection|
We need a new schema for this data and the example shows
one created as nyeats. The within that new schema a
collection is created with the name restaurants.