triggers - MySQL - capture the changes on insertion -

i have mysql table mytable 4 columns id,name,version , date. everyday data , data changes when install new version of our products.

i analyze change in version numbers on time, analyze when , how many customers installing new version.

for example,

insert mytable (id,name,version,date) values (1, 'abc','1.0','07/21/2016'); insert mytable (id,name,version,date) values (1, 'abc','1.0','07/22/2016'); insert mytable (id,name,version,date) values (1, 'abc','1.1','07/23/2016');

in case, because of change in version 1.0 1.1 capture name, id, date of 07/23/2016.

here question: how implement in mysql?

1. to implement change data capture? i'm new , couldn't find tutorials well.

2. i can think of creating trigger captures change. involves performance overhead.

3. or select work here?

any better solns?

i can bear performance! upon insert, how compare values capture change? or how track these changes?

trigger best solution here. there solution can schedule script run on every minutes or every 5 minutes , capture data change.