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
phpmyadmin
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