[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?

<http://www.mysql.com/doc/en/TIMESTAMP_pre-4.1.html>

   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.

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

                           dream.  code.




More information about the thelist mailing list