every hit not updating when i am using current_timestamp in mysql

[ramsiva]

Hi,
I have used current_timestamp, i am submitting same values then current_timestamp not updating.
I have used below for updating timestamp.
(timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)

Kindly help me to update timestamp, on every hit

[rproffitt]

There are a lot of priors on this. Read from https://www.google.com/search?q=UPDATE+CURRENT_TIMESTAMP&ie=utf-8&oe=utf-8#q=UPDATE+CURRENT_TIMESTAMP+NOT+WORKING&*

I wish you had shared more SQL statements so I could pick over that. But read the priors.

[ramsiva]

It is possible using trigger.
Can u please send the triiger code

[rubberman]

Generally, the timestamp field will not be updated unless the row has changed, update statement notwithstanding. IE, it is indicating when the row was physically updated.