At 2:09 +0200 11/7/02, Galanis Nikolas wrote:
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.
That seems fairly strange. Let's see an example.
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
