sql - MySQL: Updating entry WITHOUT updating timestamp -


I have a timestamp in the mysql table, which is "updated at CURRENT_TIMESTAMP" on what particular timestamp is a manual Is there a way to update from? (Example: Updating the entry to modify a blog post, but not doing it again)

Is there a way to manually update the timestamp on a particular occasion? (Example: Updating the entry to modify a blog post, but do not have to do this again)

It seems that you need to configure the default barrier so that It can only populate the columns on the entry:

  default CURRENT_TIMESTAMP  

To change only this means that the timestamp value will be updated to update any revision Will not trigger. IE: If you made a blog post yesterday, and have corrected a typo today - the date in the column will still be for tomorrow.


Comments