Track changes to a specific field in the database, perhaps?

Question

PHP

There is a table in the database, is it possible to track that a specific field has changed and only that! Let's say we have a table with fields name, phone, city. Need to track the city field. If the name or phone number changed, then no events, but if the city field changed, there is an event and it needs to be tracked? How can it be done?

Answer 1

Use triggers:

CREATE TRIGGER `after_update_table_name` AFTER UPDATE ON `table_name`
 FOR EACH ROW BEGIN

  IF `OLD`.`field_name` <> `NEW`.`field_name` THEN
    # Your action
  END IF;

END

https://dev.mysql.com/doc/refman/8.0/en/trigger-sy...

Answer 2

use triggers

Answer 3

Trigger to change the field and write to a separate change table.