Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but make the text show the more readable 'name' value of the linked table?

Here is what it looks like now:

what it looks like now

I want the calling value to show something like 'junior', the name value of the displayed data, but I want the value to remain as is.

share|improve this question

closed as not a real question by Nifle, Scott, Brad Patton, Dave, Ƭᴇcʜιᴇ007 May 1 '13 at 15:00

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

I don't believe it is; as far as I can tell from the phpMyAdmin instances to which I have access, you'd have to modify the phpMyAdmin source so as to have the query used to generate this view include a JOIN on the table containing the data you want displayed. Theoretically possible, but difficult and not really advisable in practice.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged .