Nick,
Friday, June 14, 2002, 3:40:23 PM, you wrote:
NW> I can't work out why this query is also updating a TIMESTAMP col?
It's a paticular feature of TIMESTAMP column. Read the manual:
http://www.mysql.com/doc/D/A/DATETIME.html
NW> UPDATE news SET title = 'new title', text = 'new text' WHE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Jay Blanchard declared
> 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 ign
{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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all
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'
The table is very simple:
* id INT
* date TIMESTAMP // this is current date when 'updating'?
* ti
