Bug #4977 | update timestamp with now() affects all timestamps | ||
---|---|---|---|
Submitted: | 10 Aug 2004 15:38 | Modified: | 10 Aug 2004 17:00 |
Reporter: | Rudolph van Graan | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.0.20 | OS: | Linux (Gentoo Linux) |
Assigned to: | Dean Ellis | CPU Architecture: | Any |
[10 Aug 2004 15:38]
Rudolph van Graan
[10 Aug 2004 17:00]
Dean Ellis
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: This is the default/intended behavior for TIMESTAMP columns. See: http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html
[30 Apr 2009 7:44]
Bogdan Gusiev
Here is a little solution how to build an update and create time stamp in the same table: http://gusiev.com/#Update%20and%20create%20timestamps%20with%20MySQL