MySQL database and table of the most basic command large inventory

Are you really frustrated with the actual operation of getting the MySQL database and the table's most basic commands? If this is the case, the following article will give you the corresponding solution, the following article is mainly about the MySQL database and table of the most basic command of the program, the following is the specific description of the relevant content.

SELECT DATABASE (); Lists the currently selected database and displays NULL if no database is selected;

Show DATABASES; Lists the MySQL databases that are currently present on the server;

Use DatabaseName; Choose to access a database;

Show tables; Find out what tables the current MySQL database contains;

DESCRIBE TableName; Lists the structure of a table;

Show INDEX from TableName; Displays the index information in the table.

The above related content is to MySQL database and table of several basic command of introduction, hope you can have some harvest.