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

share|improve this question
add comment

1 Answer

Thanks for everyone's help - I ended up writing a standard query in PHPMyAdmin that included all fields I needed, I then exported the result to an Excel spreadsheet, made the edits there, deleted the columns I no longer needed, saved it as a csv, then imported it back in.

I am mighty surprised to learn that PHPMyAdmin does not seem to have a quick and easy way to replace foreign keys with their representational values!

share|improve this answer
add comment

Your Answer

 
discard

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