Re: Can some please help me with a duplicate key error
OK, to focus on "[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Duplicate entry '' for key 2"...
Since the CREATE TABLE shows only a PRIMARY KEY, and no column named "key2", we are missing something.
RecordNumber is missing from the INSERT -- this is to be expected since it is an AUTO_INCREMENT.
Was the INSERT part of a transaction? If so, what other statements were in the transaction?
> Duplicate entry ''
That is puzzling because it implies that the empty string is the offending value.
Do you have an index called `key2` on some other table?
Subject
Written By
Posted
Re: Can some please help me with a duplicate key error
May 19, 2013 10:01PM
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.