Is it possible to find out if a record has been changed and mark it?

Question

MySQL

From csv I import into the database INSERT ... ON DUPLICATE KEY UPDATE
(if there is a record, it is updated, if not, it is created)
how can I find out if the record has been changed, and make a note about it, for example, the date of change.
in the future, these records (new and updated) will be used to update, add products to Bitrix. In order not to load the server once again by sorting through all the goods.

Answer 1

We put it on the column: ON UPDATE CURRENT_TIMESTAMP
details here