Solved

visual representation of the dependencies using phpMyadmin

Posted on 2004-09-07
1
321 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Showing random records from database 10 46
mysql database, schema and table creation 13 60
Optimize the query 5 43
Unwanted output from my query 5 17
Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

821 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