In MySQL, can we use updated_at column to update the timestamp automatically based on updates done on only a selected few columns than all the columns of that table?
Ex: If my Table t1 has columns a,b,c and an updated_at column.
I want updated_at to be updated only when columns b and c are updated and not column a. Can this be done in MySQL by altering the updated_at column??
Edit this is not a duplicate of When is a timestamp (auto) updated?
And I cant use a trigger because there are lot of bulk updates that happen all the time than single row updates. So, there is an essential degradation of update-times.
