Home > Article > Daily Programming > How to view relationship diagram in mysql
View a graph in MySQL by performing the following steps: 1. Connect to the database; 2. Execute the query: GRAPHVIZ DOT; 3. Export the image (PNG, JPEG, or SVG).
How to view the relationship diagram in MySQL
The steps to view the relationship diagram in MySQL are as follows:
1. Open the MySQL command line client
Open the MySQL command line client on your computer. You can do this by entering the following command in the terminal or command prompt:
<code>mysql -u 用户名 -p 密码 -h 主机名 -P 端口号</code>
2. Connect to the database
Use the following command to connect to the database you want to view Database for diagrams:
<code>USE 数据库名;</code>
3. Execute query
To see a graphical representation of all tables in the database, execute the following query:
<code>GRAPHVIZ DOT</code>
This query will generate a relationship diagram that contains the following information:
4. Export Image
To export the diagram as an image, use one of the following commands:
GRAPHVIZ DOT -Tpng -o filename.png
GRAPHVIZ DOT -Tjpeg -o filename.jpg
GRAPHVIZ DOT - Tsvg -o filename.svg
Example
The following example demonstrates how to view a relationship graph in MySQL:
<code>mysql -u root -p USE my_db; GRAPHVIZ DOT; GRAPHVIZ DOT -Tpng -o my_db_relationships.png</code>
After executing these commands, a relationship diagram PNG file named my_db_relationships.png
will be created in the current directory.
The above is the detailed content of How to view relationship diagram in mysql. For more information, please follow other related articles on the PHP Chinese website!