The first timestamp field in any table is always updated when the row changes:
http://www.mysql.com/doc/D/A/DATETIME.html If you don't want this behavior, use a date or datetime field instead. --jeff ----- Original Message ----- From: "Damnish" <[EMAIL PROTECTED]> To: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 9:13 AM Subject: Re: NOW() > curdate() > > ----- Original Message ----- > From: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]> > To: "MYSQL" <[EMAIL PROTECTED]> > Sent: Sunday, May 12, 2002 12:34 AM > Subject: NOW() > > > Hi, > > I have a table with a timestamp field called dtins. When i insert a row to > the table, the value of this field is setted to NOW() just for the inserted > the record. My problem is when i update some record, its dtinst value is > change again, without a ask to :( How can i avoid this? Is there another > function that i can use to get the current datetime? > > Thank u very much, > > Edilson Vasconcelos de Melo Junior > www.jrsoftwares.com.br > [EMAIL PROTECTED] > Fone: (19) 3256-3577 > > > sql,query > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.361 / Virus Database: 199 - Release Date: 7/5/2002 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
