|
>> Are you using PHPMyAdmin to administer the database, or do they have some other tool?
PHPMyAdmin.
>> You should set item number to primary key. Do not set any others to primary key, as none >> of the other fields will be unique. The primary key has to be unique. In the case where
>> none of your columns will be totally unique, then you would add a unique index (usually an >> auto_increment number of some sort) as your ID.
>> I would go ahead an index all 4 columns, as you will be searching the database from each >> of the 4 columns. Do not set any of them to unique, as the ItemNumber is the only column >> that will contain completely unique entries.
Okay. I don't think any of the columns will be unique. The reason I say that is for example one item 9601-2000 has maybe 6 or 7 colors.. so won't that be a different line on my table?
9601-2000 Black
9601-2000 Brown
9601-2000 Coral
9601-2000 Etc, etc.
So I'll add one more field called ID and make that unique?
When I go in it only let me select one radio button.. so I can only select Primary Key, Index, Unique or none.
|