{snip]
I can't work out why this query is also updating a TIMESTAMP col?
UPDATE news SET title = 'new title', text = 'new text' WHERE id = '4'
[/snip]
Because, according to TFM; (http://www.mysql.com/doc/D/A/DATETIME.html)
Automatic updating of the first TIMESTAMP column occurs under any of the
following conditions:
*The column is not specified explicitly in an INSERT or LOAD DATA INFILE
statement.
*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.)
*You explicitly set the TIMESTAMP column to NULL.
HTH!
Jay
---------------------------------------------------------------------
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
