jonathan wrote:
are you having two timestamp fields in a table (ie a created and a
last_updated)?
-j
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
Ferindo
--MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
No just the one timestamp field (last_updated) which I expect to be
given a timestamp on the initial INSERT and then continue to be
automatically updated to the current time on subsequent UPDATEs to any
given row...
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]