http://kb.owrench.com/index.php?action=history&feed=atom&title=Smart_Trivandrum_GPS_future_data_removal_querySmart Trivandrum GPS future data removal query - Revision history2026-05-04T04:22:42ZRevision history for this page on the wikiMediaWiki 1.34.2http://kb.owrench.com/index.php?title=Smart_Trivandrum_GPS_future_data_removal_query&diff=177&oldid=prevMidhungirish: Query to delete future data2025-06-11T06:56:56Z<p>Query to delete future data</p>
<p><b>New page</b></p><div>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:<br />
<code><br />
<br />
DELETE FROM st_water_gps_data WHERE sgd_imei='865006046684263' AND sgd_time>'2025-06-11 11:19:00'<br />
<br />
</code><br />
<br />
Replace the sgd_imei and sgd_time fields with relevant values.</div>Midhungirish