Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Timestamp wont Autoupdate
- Thread starter mhburney
- Start date
TonyGroves
Programmer
The record only gets physically updated if it needs to be. So, if no values have been changed, there is no need to update it. If you want to ensure that the value of a timestamp field gets updated, you need to assign it a new value:
UPDATE tbl
SET fld1='abc',fld2=456,timestampfield=NOW()
[/tt]
UPDATE tbl
SET fld1='abc',fld2=456,timestampfield=NOW()
[/tt]
- Status