How to view tables in mysql

How to view the table in mysql: first open the mysql command line editor; then enter the password, log in to the Mysql database and create the table's database; then create a table in the database; finally enter [describe table name] that is Can.

How to view tables in mysql:

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

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

#3. In the third step, we first display the database and select a database in which we want to create a table.

#4. Step 4, we use that database, of course, we can also create a new database directly.

5. Step 5, we create a table in that database.

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

Related free learning recommendations: mysql database(database)

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