How to import your existing table structure in EER diagram using MySQL Workbench?

mysql sql erd
Jerielle picture Jerielle · Mar 17, 2014 · Viewed 14.3k times · Source

I just want to ask about my problem. Right now I have an existing database and tables. And I want to get the structures of every table. I just need to get their column name for comparison for other tables.

But How can I include this in an EER diagram? What I did is I copied all the tables column in a paper and I manually inputted the details to the MySQL workbench EER tool. I have a lots of tables. So it is so difficult for me to input one by one all of the tables. Is there an easy way? Can you provide me any links how to do that? Ok that's all. Thanks.

Answer

johnpili picture johnpili · Mar 17, 2014

If you want to generate an EER Diagram of existing MySQL database you can use the Reverse Engineer feature of MySQL workbench.

Database -> Reverse Engineer

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