Utility to create "data dictionary" for MySQL database

mysql sql data-dictionary
Casey Flynn picture Casey Flynn · Jan 14, 2011 · Viewed 18.4k times · Source

I'm wondering if there is a utility that exists to create a data dictionary for a MySQL database.

I'm considering just writing a php script that fetches the meta data about the database and displays it in a logical format for users to understand but I'd rather avoid that if there is some pre-built utility out there that can simply do this for me.

Answer

Nishant picture Nishant · Jan 14, 2011

Have you looked into HeidiSQL or phpMyAdmin?

Also, MySQL Admin.

Edit#1 fixed typo, added more info

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN in MySQL?

Read More