Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to generate er diagram in mysql workbench

First make sure you have a Database and Tables created on the MySQL server.
Example :-
Database - bank.
Tables - account, branch, customer, loan, trandetails.

2. Click on Database -> Reverse Engineer.
3. Select your stored connection (for connecting to your MySQL Server in which database is present) from the dropdown. Then click Next.
4. After the execution gets completed successfully (connection to DBMS), click Next.
5. Select your Database from the MySQL Server for which you want to create the ER Diagram (in our case the database name is “bank”), then click Next.
6. After the retrieval gets completed successfully for the selected Database, click Next.
7. Select the Tables of the Database which you want to be visible on the ER Diagram (In this case I am importing all the tables of the DB), then click Execute>.
8. After the Reverse Engineering Process gets completed successfully, click Next.
9. Click Finish.
Now you can see the ER Diagram of the Database.

https://medium.com/@tushar0618




Comment

PREVIOUS NEXT
Code Example
Sql :: call rest api from postgresql 
Sql :: fanyi 
Sql :: is not null sql 
Sql :: primary key auto increment in postgresql 
Sql :: SQL SELECT-Klausel 
Sql :: aliasing in sql 
Sql :: mariadb 
Sql :: current month transactions in mysql 
Sql :: SELECT statement to find the specific cell in database table 
Sql :: postgresql replace html tags from string 
Sql :: in subquery terminology, the first query in the sql statement is known as the _____ query. 
Sql :: 10000000000000000000 am to meters 
Sql :: SQL Using Comments to Debug Code 
Sql :: Serilog Table Configurations for MSSQLSERVER SINK 
Sql :: recursive stored procedure in sql server 
Sql :: search starting with mysql 
Sql :: ring SQLite sqlite_open 
Sql :: list enums sql 
Sql :: parent: [Error: SQLITE_READONLY: attempt to write a readonly database] { 
Sql :: product of a column in mysql 
Sql :: select multiple columns count one column and group by one column in one table 
Sql :: multiple row join 
Sql :: mysql type conversion 
Sql :: spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition. 
Sql :: subconjuntos da linguagem SQL 
Sql :: mysql config slave 
Sql :: mysql equivalent decode oracle 
Sql :: Sql runnignsum 
Sql :: select month from date in sql 
Sql :: mysql insert into select with recursive 
ADD CONTENT
Topic
Content
Source link
Name
7+8 =