* Ceferino Ortega > mysql> UPDATE prueba SET fecha2= '20020313101000' WHERE id=1; > mysql> select * from prueba; > +----+----------------+----------------+ > | id | fecha1 | fecha2 | > +----+----------------+----------------+ > | 1 | 20020313101501 | 20020313101000 | > .... > +----+----------------+----------------+ > > mysql> select now(); > +---------------------+ > | now() | > +---------------------+ > | 2002-03-13 10:15:23 | > +---------------------+ > > Field 'fecha1' has changed to 'now()'. > Is this a bug?
No, it is a feature. <URL: http://www.mysql.com/doc/D/A/DATETIME.html > In short: the first timestamp field of a table is automatically updated when the row is updated/inserted. -- Roger query --------------------------------------------------------------------- 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
