My table structure is like this! Then, my statements are as follows: selecttime, Lon, Lat, wificonnect. mac_ap, wificonnect. Arg, wifinearby. mac_ap, wifinearby. 'level' fromgps, low, wificonnect, success! & Quot; 0 & quot; an mysql
My table structure is as follows:
Then, my statement is like this.
Select time, Lon, Lat, wificonnect. mac_ap, wificonnect. Arg, wifinearby. mac_ap, wifinearby.Level
From gps, low, wificonnect, wifinearby
Where Lon! = "0" and Lat! = '0'
And gps. fk_low_id = low. pk_id
AND low. pk_id = wificonnect. fk_low_id
And low. pk_id = wifinearby. fk_low_id
And wifinearby. mac_ap! = '00: 00: 00: 00: 00: 00 ';
The result is as follows:
I want to use the same lon and lat as the unique primary item and recreate a table with the same Lon, Lat, and one (Lon, Lat) corresponding to multiple APs. how can I write a statement?