Big data-how to store a series of wifi lists in mysql by category

I now have a nearby WIFI list read from the mobile phone every 30 seconds. it is in JSON format and the format is as follows! Refer to the following figure for help: ((img.ask.csdn.netupload20160125145369949347854217.png) how can I create a mysql table for easy reading? my current table is a simple list and some problems may occur ,! For example, I want to find the AP with the maximum strength standard deviation, but because of the... big data mysqljavajsonwifi

I now have a nearby WIFI list read from the mobile phone every 30 s. The list is in JSON format and the format is as follows:

How can I create a mysql table for easy reading? my current table is a simple list and some problems may occur,
For example, I want to find the AP with the largest intensity standard deviation, but I don't know how to operate because the same AP appears in different rows .. Please come up with a solution .. Is there a way to store the multi-level structure of the first image?