Mysql must know will read notes the third chapter of the display database _mysql

MySQL is an open source relational database management system (RDBMS), the MySQL database system uses the most commonly used database management language-Structured Query Language (SQL) for database management.

Show column from TableName;

Returns a row for each field that contains the field name, data type, whether NULL is allowed, key information, default value, and other information.

Describe statement: MySQL supports using Describ as a quick way to show columns from. Describ TableName

Additional show statements that are supported:

Show status, for displaying extensive server-state information

Show create DATABASE and shows create TABLE, which are used to display MySQL statements that create specific databases or tables.

Show grants, which displays the security permissions granted to the user.

Shows errors and show warnings, used to display server errors or warning messages.

MYSQL 5 supports a new INFORMATION_SCHEMA command that can be used to obtain and filter schema information.

The above is a small series to introduce the MySQL must know will read the third chapter of the display database related content, hope to help everyone!