Difference between revisions of "Smart Trivandrum GPS future data removal query"
Jump to navigation
Jump to search
Midhungirish (talk | contribs) (Query to delete future data) |
(No difference)
|
Latest revision as of 12:26, 11 June 2025
Sometimes GPS devices sends future data to the server and there will be request from the agencies to delete such data. Following query can be used to clear the data:
DELETE FROM st_water_gps_data WHERE sgd_imei='865006046684263' AND sgd_time>'2025-06-11 11:19:00'
Replace the sgd_imei and sgd_time fields with relevant values.
