If you have 2 timestamp fields, they both get set at insert, but only
the first is modified on an update.
mblack wrote:
>
> According to the manual, TIMESTAMP will update every time the
> current record is changed. This, by the functionality, would be
> more appropiate for a date_modified field than a date_created field.
> It sure would be nice to set the default of a field to a return value of
> a system function like SYSDATE, the same as AUTO_INCREMENT
> works for numeric fields.
>
> Michael Black
>
> On Thu, 07 Oct 1999, sinisa@stripped wrote:
> > mblack writes:
> > > Is it possible to set the default of a column to the result of a function
> > > when creating or altering a table?
> > >
> > > Ex: date_created datetime default SYSDATE(),
> > > --
> > > Michael Black, Senior Consultant
> > > CRM and ERM Specialist
> > > Information Management Systems Consulting, Inc.
> > > www.imsconsulting.com
> > > 18500 Von Karman, Suite 540
> > > Irvine, CA 92612 USA
> > > Voice 877.756.5757
> > > Fax 949.862.5600
> > >
> > >
> > >
> > >
> >
> > HI!
> >
> > No, there is no general feature like that, but for your example there
> > is a column type of TIMESTAMP.
> >
> > Read about it in a manual.
> >
> > Sinisa
> >
> > +----------------------------------------------------------------------+
> > | TcX ____ __ _____ _____ ___ == mysql@stripped |
> > | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
> > | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
> > | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
> > | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
> > | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> > | /*/ \*\ Developers Team |
> > +----------------------------------------------------------------------+
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail mysql-thread15456@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail mysql-unsubscribe@stripped instead.
> --
> Michael Black, Senior Consultant
> CRM and ERM Specialist
> Information Management Systems Consulting, Inc.
> www.imsconsulting.com
> 18500 Von Karman, Suite 540
> Irvine, CA 92612 USA
> Voice 877.756.5757
> Fax 949.862.5600
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15460@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
