Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm using phpMyAdmin (PHP & MySQL) and I'm having a lot of trouble linking the tables using foreign keys.

I'm getting negative values for the field countyId (which is the foriegn key). However, it is linking to my other table and cascading fine.

When I go to add data there will be a drop selection for the CountyId and the values will look something like this:

" -1

1- "

Here is my alter statement:

ALTER TABLE Baronies
 ADD FOREIGN KEY (CountyId)
 REFERENCES Counties (CountyId)
 ON DELETE CASCADE
share|improve this question

migrated from superuser.com Mar 21 '10 at 23:26

This question came from our site for computer enthusiasts and power users.

2 Answers 2

I'm using 3.3.2deb1 version and "Choose field to display" doesn't appear.

share|improve this answer

It is not negaitve number, the feature of phpMYAdmin is to show foreign key value and a custom description field next to it. In the referenced table (Counties) you can go to "Relation view" and under the table there is a select box "Choose field to display", in which you choose value that will be displayed next to CountyID value in the referencing table (Baronies). Also see: phpymadminWiki

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.