I have a .csv file with the positions of a mobile object. Every time the position of the object is updated and a new position is recorded.
I want to read the .csv at each time interval to enter the data in a mysql table, but as I read all the .csv, if I register a autoincremental field, I multiply the data for each reading of the .csv by entering not only the new value but the previous ones.
How can I skip the data already recorded in the table and read only the new .csv data?