> I think I've seen this complaint posted before but I ignored but now I
> realize that in some of my db tables' last_updated field the value is
> automatically updating on UPDATEs to records while in other tables the
> last_updated fields for some strange reason aren't automatically updating.
> 
> I'll usually use the following line in my table declarations:
> 
> last_updated  TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
> 
> In some tables it automatically updates on subsequent updates to the
> table and in others it will not. The purpose here is to have the
> last_updated field automatically append to the current timestamp... the
> application on the front end doesn't specify the time to MySQL but
> rather expects that it's always going to be UPDATEd to the current time
> slot.
> 
> What am I doing wrong what command should I issue to my tables to
> correct it? Thanks

What veriosn of mysql, timestamp handling has changed from one version to
the next?

Perhaps you have others in your table, I think only the first is updated, at
least, in pre 4.1 days, after that, check the docs for the correct behavior.
-- 
-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
<http://www.newgeo.com>                     Novato, CA U.S.A.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to