jagguy
asked on
primary key confusion
Hi,
In phpmyadmin I cant alter tables to get the primary key. I want to set a primary key with autonumber and I know I check on a-I on creating a field .
If you see the img I have a field with PK that I cant undo the PK and I cant add a autonumber field as a PK as I get an error (need a PK)
mysql.docx
In phpmyadmin I cant alter tables to get the primary key. I want to set a primary key with autonumber and I know I check on a-I on creating a field .
If you see the img I have a field with PK that I cant undo the PK and I cant add a autonumber field as a PK as I get an error (need a PK)
mysql.docx
Consider recreating the table. You might write a little script to copy the data to the new table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please use image files like JPGs for screen shots. They will open in the browsers where 'docx' files require us to start up another program. I usually won't do that and I haven't looked at your file.