PHPMyAdmin - Can I view actual field values instead of the foreign keys?
- by Callum
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.