To track changes to specific fields in your database, perhaps?

Question

To track changes to specific fields in your database, perhaps?

There is a table in the database, is there a way to track what has varied particular field and only it! Let's say we have a table with fields name, phone, city. Need to keep track of the city box. If changing the name or the phone, not the event, but if changing the box city event is and it need to track? As it is possible to do this?

maxie.Mertz11 asked April 19th 20 at 12:41

Related questions

More answers about "To track changes to specific fields in your database, perhaps?"

3 answers

Mattie_Bay answered on April 19th 20 at 12:45

to use triggers

alda_Nikolaus59 answered on April 19th 20 at 12:47

Trigger on field change and record in a separate table of amendments.

I don't understand how to trigger the right to write)
if update tablename (how to specify a specific field)
insert into logs value(vol, vol, vol)

field how to specify? - maxie.Mertz11 commented on April 19th 20 at 12:50

@Melisa.Reilly, IF OLD.fielf <> NEW.field - alda_Nikolaus59 commented on April 19th 20 at 12:53

randal75 answered on · Accepted Answer · 2020-04-19T12:43:45.489Z

randal75 answered on April 19th 20 at 12:43

Solution

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...