mairving — Tue, 17 Feb 2004 17:21:51 +0000

The first time that I did it, I updated based on 'WHERE staff_id='value' . The second time that I updated, I updated it on 'WHERE staff_id='value' and department_id='value2' . Both gave the same results. I was really just adding some values to the database as a test anyway.

Thanks, bud.

druagord — Tue, 17 Feb 2004 17:13:35 +0000

Yes a SELECT will assure you there is only one row. But the way i see it if staff_id 1 is in two departement or as 2 title it will be there more then once.

mairving — Tue, 17 Feb 2004 17:09:13 +0000

The version is 4.018. I tried it several different times and I know that only one record existed for the staff_id. I will play with it again and make totally sure by running a select statement prior to changing the field as a test.

druagord — Tue, 17 Feb 2004 16:51:25 +0000

weird if i have been using Mysql 4.0 for a while now and i didn't notice that behavior. I also use this kind of link table (crossover table). what version are you running. are you sure there is only one row with that value.