merging tables

[Walter deMilly]

I have a mysql db which has some tables I want to merge.

Table 1 has data from 1/1/2013 to 12/01/2017.

Table 2 has data from 11/15/2017 to 12/29/2017.

The tables have identical schemas.

I want to merge these tables in a way that preserves the entirety of Table 2,
and "deletes" any data in Table 1 which goes beyond 11/14/2017.

There are about 210 tables which are structured this way.

I can do this manually but when I tried the other day, I lost all of the data in table 2.

Is there a script or method you can suggest?

Thanks.