|| at Jun 14, 2002 at 12:33 pm
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'
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
*The column is not specified explicitly in an INSERT or LOAD DATA INFILE
*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
*You explicitly set the TIMESTAMP column to NULL.