The first timestamp in any table is automatically updated by mysql every time you modify that record. It is the modify timestamp
If you wish to use the timestamp in your table, you should create two timestamps at least and use the second one Modstamp timestamp Usable timestamp See here http://www.mysql.com/doc/D/A/DATETIME.html starting on the fourth paragraph I'll take my beer via air mail :) > -----Original Message----- > From: Wouter van Vliet [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 9:53 AM > To: [EMAIL PROTECTED] > Cc: Wouter @ Witbier > Subject: timestamp problem .. > > > Heey Folks, > > I'm having a slight problem with the timestamp column format. > When I alter a > table and, add a column of type timestamp all records get the current > timestamp, that's ok. When i insert a new row, all records > get the current > timestamp. That too is ok. But now, when I update one row of > the table, that > row gets a new timestamp. And that's not what i'd like it to do. Does > somebody have any idea on how this can be prevented? > > I've tried to make the column of type int(14) and then set now() or > UNIX_TIMESTAMP as default value, but that just results in a > very well known > error 1064 (You have an error in your SQL syntax near 'NOW()' > at line 1). > > Thanks ! > Wouter > > (ps. beer for the helper .. if you'd come up with some idea > to give it to > you) > > > > --------------------------------------------------------------------- > 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
