MySQL most common action statement summary

This article mainly introduced the MySQL most common Operation statement summary, with the table and the library related these statements is the study MySQL most basic knowledge, needs the friend may refer to under

Here are a few days I have been using a few commands, first write down, will be a copy of the MySQL detailed use of the document

Note: [] to represent the name, you need to replace the library name or table name

Show All libraries:

?

1	show databases;

To enter a library:

?

1	use [dbname];

Show All tables:

?

1	Show tables;

Displays the field configuration for a table:

?

1	describe [Tbname];

Or

?

1	Show full fields from [Tbname];

To create a library:

?

1	Create DATABASE [dbname];

To delete a table:

?

1	drop database [dbname];

To delete a table:

?

1	drop table [Tbname];

Import Create script:

?

1	Mysql-u[user]-P [dbname] < [Create.sql]

(If you do not have a password, you do not need-p)

Shows the status of data storage for each table, and so on:

?

1	Show Table Status G;

That's it.