php with mysql

I had an interesting phone call from someone wanting to move from MongoDB to MySQL's new JSON Document Store. The big question was 'How do I export my Mongo data into something I can read into MySQL?" The good news is that the folks at Mongo have given us the tools for the hard part of a simple process. For this example I am going to use some test data create previously in a database creatively named dave . The numbers are made up and I am using my name and the names of the canines residing in my home. So a quick peek at the data: $ mongo MongoDB shell version: 3.2.8 connecting to: test > use dave switched to db dave > db.dave.find() { "_id" : 123, "name" : "Dave" } { "_id" : 456, "name" : "Jack" } { "_id" : 789, "name" : "Dexter" } { "_id" : 787, "name" : "Boo" } > bye Dumping That Data First use mongodump -d dave to write out the data much

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 collection Collections 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 Enter password: Default schema `test` accessible through db. Welcome to MySQL Shell 1.0.4 Development Preview Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type '\help', '\h'