Import a JSON Data Set into MySQL
JSON Data Into MySQL JSON is now a very hot format for sharing data and MySQL's 5.7 Data Set is now a very hot way of storing that data. But I have had some requests on getting a raw JSON data set into MySQL. So lets start with Global Airfields data from the Awesome JSON Datasets collection. airfields.json The data is in a file named airfields.json and comes as one very long line. MySQl has now way of taking out the individual JSON documents from that string and putting them in a row. The jq tool will let use see the data broken down into objects. Try jq -C '.[]' airfields.json and you will see individual documents colorized. { "ID": "LFOI", "ShortName": "ABBEV", "Name": "ABBEVILLE", "Region": "FR", "ICAO": "LFOI", "Flags": 72, "Catalog": 0, "Length": 1260, "Elevation": 67, "Runway": "0213...
