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