PHPMyAdmin - Can I view actual field values instead of the foreign keys?

Posted by Callum on Server Fault See other posts from Server Fault or by Callum
Published on 2010-09-14T07:15:54Z Indexed on 2011/01/06 8:55 UTC
Read the original article Hit count: 287

Filed under:

I have a database with some MyISAM tables. The tables contain foreign key relationships, but they are not inherently "enforced" (I believe "referential integrity" is the term).

Using PHPMyAdmin, what I'd like to do is be able to view records from the tables but have all foreign keys replaced by whatever value they are representing.

Eg, instead of seeing:

23 | 14 | $6.50

I'd like to see..

Extra Large | Thin Crust | $6.50

($6.50 would be an editable field, the first two fields would not be).

Any helpers? Thanks.

© Server Fault or respective owner

Related posts about phpmyadmin