I'm using the MySQL Workbench to run a duplicate data removal query. When I run the query for a very large table, because of the 600-sec connection limit of the Workbench, it results in Lost Connection. Even so, the duplicate values disappear. Then the question came to me: The code I'm using to check for repeated lines is:
SELECT TS_SAMPLETM, COUNT(*) FROM HT_MA2_SBX_SEG
GROUP BY TS_SAMPLETM
HAVING COUNT(*) > 1
Even the Workbench losing connection to the server, does the query run to the end?