Hi, Take a look here :
http://www.mysql.com/doc/en/DATETIME.html "Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: a.. The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. b.. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) c.. You explicitly set the TIMESTAMP column to NULL. TIMESTAMP columns other than the first may also be set to the current date and time. Just set the column to NULL or to NOW(). " Regards, Jocelyn ----- Original Message ----- From: "ozy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 22, 2002 7:16 PM Subject: unwanted timestamp update > Hello everyone, > > /first of all, sorry about my bad english :-)/ > > i had just found some interesting thing with MySQL 3.23 (win2000). > > i have a table like this: > +------------+---------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +------------+---------------+------+-----+---------+-------+ > | page | varchar(255) | YES | | NULL | | > | host | varchar(255) | YES | | NULL | | > | browser | varchar(255) | YES | | NULL | | > | referer | varchar(255) | YES | | NULL | | > | datum | timestamp(14) | YES | | NULL | | > | discrete | char(1) | YES | | NULL | | > | counter_id | int(11) | YES | | NULL | | > | hely | varchar(255) | YES | | NULL | | > +------------+---------------+------+-----+---------+-------+ > it is just a work table so nothing interesting. > > "hely" is NULL for all of the records, "datum" is different for (almost) all. > ("datum" is a hungarian word for "date"). > > now i run an SQL query like this one: > > update szurtcounter set hely='kulfold'; > > after that the value of "hely" for all of my records is 'kulfold', > BUT!! the value of the "datum" field is THE CURRENT SYSTEM TIME also for all of my > records! > > i don't get this one :-( > > thanks for any help > > -- > Best regards, > Csite Laszlo aka ozy > > > --------------------------------------------------------------------- > 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
