- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
How to get ER model of database from server with MySQL Workbench?
To get ER model of database from server, you need to first launch MySQL Workbench. The snapshot is as follows −
After that you need to select the “Database” menu −
After that a wizard will open as in the following screenshot. Add the password and press OK twice.
After pressing the OK button, you will get the next wizard and you need to press next button. The following would be visible now −
After that you need to select “Model” menu as I have marked in the above wizard.
Model->Create Diagram from Catalog Objects After selecting the option, you will get the ER model of database.
The following is the screenshot −
Here is the sample ER diagram of our database −
- Related Articles
- Create a new database with MySQL Workbench?
- How to take MySQL database backup using MySQL Workbench?
- How can we get the list of tables in a particular database from MySQL Server command line?
- Attributes to Relationships in ER Model
- How to get field name types from a MySQL database?
- After connecting to MySQL server how can we select a database from\ncommand prompt?
- Get a list of Constraints from MySQL Database?
- How can we analyze the tables of a particular database from MySQL Server command line?
- How to get username using ID from another table in MySQL database?
- How to copy tables or databases from one MySQL server to another MySQL server?
- What kinds of programs are available in MySQL database to manage MySQL server?
- Get the last record from a table in MySQL database with Java?
- How can we create user accounts in MySQL database server?
- How to get the server IP with Laravel?
- How to upgrade MySQL server from command line?