Syntax error How to Auto Generate Database Diagram in MySQL?

How to Auto Generate Database Diagram in MySQL?

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 −

Updated on: 2019-07-30T22:30:24+05:30

495 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements