Re: [GENERAL] Duplicate Key Violates Unique Contraint when Updating a table

2007-06-24 Thread Ragnar
On sun, 2007-06-24 at 16:55 +0800, carter ck wrote: > I am experiencing thgis problem since this morning. I seldom heard about > unique key constraint violation to happen when updating a table. > > It happens to 1 or few records at early stage, but then to all. > > My updating command is as foll

[GENERAL] Duplicate Key Violates Unique Contraint when Updating a table

2007-06-24 Thread carter ck
Hi all, I am experiencing thgis problem since this morning. I seldom heard about unique key constraint violation to happen when updating a table. It happens to 1 or few records at early stage, but then to all. My updating command is as following: update mytable set my_status='Y' where myid='