I am doing a rather large query that hits MySQL connection timeout. I know how to change the timeout parameter, but I'm also query from a laptop that can't be left running for long.
The database admin told me that I could send the results to a table instead. After searching around, it seems like
INSERT INTO dst_tbl SELECT * FROM src_tbl; is basically the idea (source article).
But even if my results are saved, will the query picked up from where it stopped when I reconnected? Is there a way to check that I'm not missing / duplicating records?
More generally, I'd appreciate any recommendation about how to do large query under timeout constraint.