June 01, 2004

MySQL timestamp fields

Interesting behavior that I wasn't aware of... automatic updates of MySQL timestamp fields. Also see the 4.1 manual.

Any update that changes data and doesn't set the first timestamp column value explicitly will cause it to be updated. The logic is reasonable, but I missed it somehow.

Posted by Dave at June 1, 2004 09:16 AM
Comments