List:General Discussion« Previous MessageNext Message »
From:Barry Date:March 31 2006 2:04pm
Subject:Re: TIMESTAMP field not automatically updating last_updated field
View as plain text  
Hank wrote:
> Are the other fields in the update statement actually changing the
> data? I don't know for sure, but if the data on disk is the same as
> the update statement, mysql won't actually update the record, and
> therefore might not update the last_updated field also.  Just a
> thought.

It's true. No Update = No change of timestamp!

-- 
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
Thread
TIMESTAMP field not automatically updating last_updated fieldFerindo Middleton Jr31 Mar
  • Re: TIMESTAMP field not automatically updating last_updated fieldScott Haneda31 Mar
  • Re: TIMESTAMP field not automatically updating last_updated fieldjonathan31 Mar
    • Re: TIMESTAMP field not automatically updating last_updated fieldFerindo Middleton Jr31 Mar
      • Re: TIMESTAMP field not automatically updating last_updated fieldHank31 Mar
        • Re: TIMESTAMP field not automatically updating last_updated fieldBarry31 Mar
        • Re: TIMESTAMP field not automatically updating last_updated fieldFerindo Middleton Jr1 Apr
          • Re: TIMESTAMP field not automatically updating last_updated fieldFerindo Middleton Jr1 Apr
  • Re: TIMESTAMP field not automatically updating last_updated fieldJonathan Mangin2 Apr