From: Andy Harrison
Date: March 21 1999 6:16pm
Subject: Primary Key trouble
List-Archive: http://lists.mysql.com/mysql/722
Message-Id: <36F5377D.63E2FD49@twmaine.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

I'm working on getting Access to use my mySQL database and I've had a
lot of success.  But now I'm stuck on something that I just can't
knock.  In order for the myAccess add-in to work 100%, you have to have
a primary key defined.  No problem, I had it working fine.  Access could
enter data, no sweat.

After I got it working, I went and made some changes and basically
recreated the mySQL database I had going.  Now it's time for the primary
key.  I'm keying off of a char(50) field called simply Name.  There are
no duplicate values in this.  I combed the entire table several times
ensuring there were no dupes, plus had someone else comb through it as
well.  There are 552 rows of data and I'm 110% certain that no two Name
fields contain the same data.

Now, when I go to create the primary key on the name field, I modify the
Name field appropriately, click the Alter Table button, and I get:

Executing "alter table ip add primary key (Name(30)) " -> * ERROR *
Can't write, duplicate key in table 'A-280'

(the reason it says (Name(30)) in this example is because I was trying a
smaller key to see if that helped)

I'm not sure quite what that error message means.  I looked at row 280
to see if that contained a dupe and it didn't.

Can anyone help me out?  Thanx!

--

          .==,_
         .===,_`\                                Andy Harrison
       .====,_ ` \      .====,__
 ---     .==-,`~. \           `:`.__,     __
  ---      `~~=-.  \           /^^^      / /    __  _  _  _  _ __  __
    ---       `~~=. \         /         / /__  / / / \// //_// \ \/ /
                 `~. \       /         /____/ /_/ /_/\/ /___/  /_/\_\
                   ~. \____./           ...for IQs GREATER than 98...
                     `.=====
                  ___.--~~~--.__
        ___\.--~~~              ~~~---.._|/
        ~~~"                             /