Shulou(Shulou.com)06/01 Report--

Editor to share with you how to query mysql database table field types, I hope you will learn a lot after reading this article, let's discuss it together!

In the mysql database, you can query the field type of the data table through the DESCRIBE statement; this statement can display the field information of the table in the form of a table, including field name, field data type, whether it is the primary key, whether there is a default value, etc.; the syntax structure is "DESCRIBE table name", which can be abbreviated to "DESC table name".

DESCRIBE: show the table structure in tabular form

The DESCRIBE/DESC statement displays the field information of the table in the form of a table, including field name, field data type, whether it is a primary key, whether there is a default value, etc.

The syntax format is as follows:

DESCRIBE

Or simply written as:

DESC

[example 1] use DESCRIBE and DESC to view the table structure of table tb_emp1, the SQL statement and the running result are as follows:

Mysql > DESCRIBE tb_emp1 +-+-+ | Field | Type | Null | Key | Default | Extra | + -+ | id | int (11) | YES | | NULL | name | varchar (25) | YES | | NULL | | deptId | int (11) | YES | | NULL | | salary | float | YES | | NULL | | + -- + 4 rows in set (0.14 sec) mysql > DESC tb_emp1 +-+-+ | Field | Type | Null | Key | Default | Extra | + -+ | id | int (11) | YES | | NULL | name | varchar (25) | YES | | NULL | | deptId | int (11) | YES | | NULL | | salary | float | YES | | NULL | | + -+ 4 rows in set (0.14 sec)

The meanings of each field are as follows:

Null: indicates whether the column can store NULL values.

Key: indicates whether the column is indexed. PRI indicates that the column is part of the table primary key, UNI indicates that the column is part of the UNIQUE index, and MUL indicates that multiple occurrences are allowed in a given value in the column.

Default: indicates whether the column has a default value, and if so, what the value is.

Extra: indicates additional information that can be obtained about a given column, such as AUTO_INCREMENT, and so on.

After reading this article, I believe you have a certain understanding of how to query the mysql database table field types, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.