are you having two timestamp fields in a table (ie a created and a
On Mar 30, 2006, at 5:17 PM, Ferindo Middleton Jr wrote:
> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?