Hi guys,
Been trying to use ON DUPLICATE KEY UPDATE on a MyISAM table with a
multi-column primary key, and I keep getting a syntax error message.
eg

INSERT INTO contacts_extra (contact_id, keyword, value)
VALUES (1, '10/Primary food activity', '2')
ON DUPLICATE KEY UPDATE `value`='2';

on a table like
CREATE TABLE `contacts_extra` (
`contact_id` INT UNSIGNED NOT NULL
,`keyword` VARCHAR(63) NOT NULL
,`value` VARCHAR(255) NOT NULL
,PRIMARY KEY (`contact_id`, `keyword`)
) TYPE=MyISAM;

Is there something special about multi-column keys that prevents on
duplicate key update from working? Or have I really made a silly
syntax error?

Thanks,
J.