Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated.
On Wed, 6 Nov 2002, Paul DuBois wrote: > At 23:47 +0000 11/6/02, Nikolas Galanis wrote: > >Hello > > > >I have a column of type timestamp(14) and I thought it would not be > >updated on a query with simple select statements, though it does! I > >read in the manual that it > >shouldn't, what could be wrong? Thanks. > > You're saying that performing a SELECT on the table causes the > TIMESTAMP column to *change*? That shouldn't happen. > --------------------------------------------------------------------- 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