- flatten every data in the array or nested array into entries.
- convert json to mysql script for Data scientist to analyze the json data more easily on database.
- json :
- result:
- this cannot handle with the null array.
- data.log contains manual things to do.
- schema type which need manual revise.
- length of data which longer than varchar(1000),needed to be changed to text
- column name may exceed the legit length of MySQL, so it should be manually decreased.