At 15:50 +0000 2/5/04, Daniel R. Anderson wrote:The table had no rows when I did this insert. So there couldn't possibly be a problem with a duplicate key. I think there was a problem with the table I dropped and recreated. I was getting other weird errors and searching the archives told me to REPAIR TABLE them. So something's messed up.
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 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 in the future if this happens and I've got things in my database I don't want to DROP?
Can't tell why it happened without more information about your situation.
-Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
