You may SELECT the current value and write it back explicitely when UPDATEing the table. Then it stays as it was.
Thomas On Mon, 13 May 2002, Jeff Kilbride wrote: > 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 > --------------------------------------------------------------------- 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