> 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]