What does this error mean: Duplicate entry '273' for key 1

2004-02-05 Thread Daniel R. Anderson
I got the following error on a perl script: Duplicate entry '273' for key 1 I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this happen, why did dropping and recreating work, and what can I do

Re: What does this error mean: Duplicate entry '273' for key 1

2004-02-05 Thread Duncan Hill
On Thursday 05 February 2004 15:50, Daniel R. Anderson wrote: I got the following error on a perl script: Duplicate entry '273' for key 1 I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this

Re: What does this error mean: Duplicate entry '273' for key 1

2004-02-05 Thread Paul DuBois
At 15:50 + 2/5/04, Daniel R. Anderson wrote: I got the following error on a perl script: Duplicate entry '273' for key 1 It means you tried to set the value of the column corresponding to key one to 273, and there was already a record that had that value. I googled for it and found a thread

Re: What does this error mean: Duplicate entry '273' for key 1

2004-02-05 Thread Daniel R. Anderson
Paul DuBois wrote: At 15:50 + 2/5/04, Daniel R. Anderson wrote: I got the following error on a perl script: Duplicate entry '273' for key 1 It means you tried to set the value of the column corresponding to key one to 273, and there was already a record that had that value. I googled for

Re: What does this error mean: Duplicate entry '273' for key 1

2004-02-05 Thread Sergei Golubchik
Hi! On Feb 05, Daniel R. Anderson wrote: I got the following error on a perl script: Duplicate entry '273' for key 1 I googled for it and found a thread telling me to DROP the table and re CREATE it. So I did, and my script is working fine. My question: why did this happen, why did