From: Steve Meyers [mailto:[EMAIL PROTECTED] > David Griffiths wrote: > > I'm not sure what the sql standard says on the matter, but > Oracle, DB2 > > and Postgres would through an exception. In fact, there is > a page on > > MySQL "gotachs" to document MySQL behaviour when it differs > > significnatly from other databases (like the first datetime > field in a > > table getting a value if none is provided during insert). > > I assume you mean "timestamp", not "datetime". Not trying to > be picky, I just don't want to confuse anyone out there.
While we're being picky, then, the first timestamp field is actually updated on any INSERT or UPDATE, not just given a value on the initial INSERT. :) -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]