Home >Database >Mysql Tutorial >How to view the mysql database table structure diagram

How to view the mysql database table structure diagram

coldplay.xixi
coldplay.xixiOriginal
2020-08-27 15:15:535202browse

How to view the table structure diagram of mysql database: first open the mysql command line editor and log in to the Mysql database; then select the database where you want to create a table, and create a table in the database; finally enter the describe table name. .

How to view the mysql database table structure diagram

Related learning recommendations: mysql tutorial

How to view the mysql database table structure diagram:

The first step is to open the mysql command line editor.

How to view the mysql database table structure diagram

In the second step, we enter the password and log in to the Mysql database.

How to view the mysql database table structure diagram

#The third step, we first display the database and select a database where we want to create a table.

How to view the mysql database table structure diagram

#The fourth step is to use that database. Of course, we can also create a new database directly.

How to view the mysql database table structure diagram

The fifth step is to create a table in that database.

How to view the mysql database table structure diagram

Finally, we enter describe the table name; we can display the table structure.

How to view the mysql database table structure diagram

Related learning recommendations: Programming video

The above is the detailed content of How to view the mysql database table structure diagram. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn