as the user
Akina said Replace INTO works
REPLACE INTO Table_copy SELECT * FROM Table WHERE Table.Counter >= SELECT(MAX(Counter) FROM Table_Copy)