Trouble performing an update

2005-03-16 Thread Bob Dankert
I am trying to update a link table (table with two primary keys) where I want to update all rows where the first primary key is a set value (for example, change key1 from 10 to 20), but I only want to update these where the resulting primary key does not already exist in the table (otherwise an

RE: Trouble performing an update

2005-03-16 Thread Gordon
PM To: mysql@lists.mysql.com Subject: Trouble performing an update I am trying to update a link table (table with two primary keys) where I want to update all rows where the first primary key is a set value (for example, change key1 from 10 to 20), but I only want to update these where the resulting