I have a table named **Analysis\_Data** that stores metrics data generated by a *software agent* based on code analysis. The *agent* inserts the metrics into the **Analysis\_Data** table automatically and it deletes some metrics from the previous analysis. However, I want to preserve all data from the **Analysis\_Data** table.

Is there any mechanism available in mysql that would automatically copy the newly inserted rows from the **Analysis\_Data** table to another table **Saved\_Data** so that I have the data available even if the *agent* deletes rows in the later analysis cycles?

I am using mysql version 14.14 distrib 5.7.13.