Query mysql still running after Lost Connection?

1

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?

    
asked by anonymous 22.02.2016 / 14:19

0 answers