[thelist] Q on mySQL defaults...

Hassan Schroeder hassan at webtuitive.com
Thu Apr 8 10:36:03 CDT 2004

jsWalter wrote:

> is there a way to have mySQL auto insert the current DATE into a field when
> a record is created, but when it's not updated?


   The TIMESTAMP column type provides a type that you can use to
   automatically mark INSERT or UPDATE operations with the current
   date and time. If you have multiple TIMESTAMP columns in a table,
   only the first one is updated automatically.

Hassan Schroeder ----------------------------- hassan at webtuitive.com
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                           dream.  code.

More information about the thelist mailing list