It seems to me that the _mysql manual_ gives a most straightforward and useful
explanation:
"If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0), and a
row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY,
an UPDATE of the old row is performed. F
From: Mark Benson <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL version issue
Date: Tue, 04 Jan 2005 14:43:48 +
As some of you will recall, I enquired on this list about versions of MySQL
and PHP a while back regarding and issue wit using the 'ON DUPLICATE
As some of you will recall, I enquired on this list about versions of MySQL and
PHP a while back regarding and issue wit using the 'ON DUPLICATE KEY UPDATE'
command in MySQL INSERT queries. Having upgraded our in-house system to PHP5
and MySQL 4 the issue was no longer a problem.
However I have