Summary of the most common MySQL statements

Summary of the most common MySQL statements

The following are some of the commands I have been using over the past few days. Write them down first and I will sort out a detailed mysql usage document.
Note: [] indicates the name, which must be replaced by the database name or table name.
Show all databases:

Show databases;

Enter a database:

Use [dbname];

Show all tables:

Show tables;

Display the field configuration of a table:

Describe [tbname];

Or

Show full fields from [tbname];

Create a database:

Create database [dbname];

Delete table:

Drop database [dbname];

Delete table:

Drop table [tbname];

Import the creation script:

Mysql-u [user]-p [dbname] <[create. SQL]

(-P is not required if there is no password)

Displays the data storage status of each table:

Show table status \ G;

That's it.