Duplicate Key for auto increase field
Posted by:
nbee78
Date: June 14, 2005 02:15AM
Hi all,
I am using mySQL 4.1.6 .
I have a table A with 3 columns A_1, A_2, A_3.
A_1: auto increase field.
A_2: unique name
A_3: description.
Large amount of data will be inserted into this table. And sometimes, it said: Duplicate Key and from that time, I can not insert data until I repair table. I guess there are some problems with the auto-increase field.
Have anybody got experience about this? Could you please share the solution!
Thank you very much!
Subject
Written By
Posted
Duplicate Key for auto increase field
June 14, 2005 02:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.