MYSQL is required to take reading notes. Chapter 3: Display database _ MySQL

MySQL is an open-source relational database management system (RDBMS). the MySQL database system uses the most common database management language-Structured Query Language (SQL) for database management. Next, I will introduce to you through this article that MYSQL must know and take notes. Chapter 3 shows that MySQL is an open-source relational database management system (RDBMS ), the MySQL database system uses the most common database management language-Structured Query Language (SQL) for database management.

Show column from tablename;

Return a row for each field. the row contains the field name, data type, whether to allow NULL, key information, default value, and other information.

Describe statement:MySQL supports using describ as a shortcut to show columns from. Describ tablename

Other show statements supported:

Show status, used to display a wide range of server status information

Show create database and show create table are used to display the Mysql statements used to create a specific database or table.

Show grants is used to display the security permissions granted to users.

Show errors and show warnings are used to display server errors or warning messages.

MYSQL 5 supports a new information_schema command to obtain and filter mode information.

The above is a small Editor to introduce you to MYSQL, you must know that reading notes Chapter 3 shows the relevant content of the database, I hope to help you!