How to Auto Generate Database Diagram in MySQL?

MySQLMySQLi Database

To auto generate database diagram in MySQL, use MySQL workbench. For this, select the option from database as shown below −

Database->Reverse Engineer

Here is the snapshot showing the Database tab −

After clicking “Database” above, choose the option “Reverse Engineer”. This state the “Reverse Engineer” mode.

Clicking above will display the following table automatically. We had one table in the database “business”. The same table “tblstudent” is visible here −

Published on 21-Dec-2018 12:38:27