I have parent table let say
CAR, and its multiple props/records in child table let say
modified_date column like
`modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
CAR along with its all properties are treated as single object, we are expecting any change on its props (
CAR_PROPS) alone should also update the parent table (
However this is not real since
CAR doest really updated hence
modified_date is not changed when any of its child record got updated.
To simplify i want sql column modified_date to be updated, though i dont have anything/anyother column to update in the row.
How to solve this problem?
NOTE: I dont want to pass the modified_date from server, just want go with DB timestamp.