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

Reply via email to