Solved

visual representation of the dependencies using phpMyadmin

Posted on 2004-09-07
1
323 Views
Last Modified: 2006-11-17
Hello ..I am relatively new to Mysql .I am using phpMyadmin as the graphical client.The database I working right now is pretty complex(I did not desgign it).I was wondering if there is any feature in phpMyadmin wherein I can see the structure of the tables in graphical form ...something like
an ER diagram..(like we see in SQL ..and in some clents in Oracle)

I appreciate your time.Would go a long way in helping me understand mysql db in general
0
Comment
Question by:micro_learner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 33

Accepted Solution

by:
snoyes_jw earned 500 total points
ID: 12007253
I don't believe there is anything in phpMyAdmin to do it.  Part of the problem is that the default table type for MySQL doesn't enforce foreign keys.  Unless you are using InnoDB, MySQL has no idea what tables are linked to each other.  AFAIK, you'll have to draw such a diagram by hand.  You might import the tables into some tool like Access that has a quasi-decent relationship diagram editor, so all you have to do is drag and drop on the relationships.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question