"Database" "The desc of MySQL view table structure details

In MySQL, if you want to see the definition of a table, you have the following options

1. Show CREATE TABLE statement:

Show CREATE TABLE table_name;

2. DESC TABLE_NAME Statement:

CREATE TABLE person (    ID int. NOT NULL auto_increment primary key,    name varchar (8),    index Ix__person__name (nam e));d ESC person;+-------+------------+------+-----+---------+----------------+| Field | Type       | Null | Key | Default | Extra          |+-------+------------+------+-----+---------+----------------+| ID    | int    | NO   | PRI | NULL    | auto_increment | | name  | varchar (8) | YES  | MUL | NULL    |                | +-------+------------+------+-----+---------+----------------+

From this example, it can be seen that:

Field: Fields represent column names

Type: The field represents the data type of the column

Null: The field indicates whether the column can take a null value

Key: In MySQL, key and index are the same meaning, this key column may see the following values: PRI (primary key), MUL (normal B-tree index), UNI (unique index)

Default: Column Defaults

Extra: Other information

"Database" "The desc of MySQL view table structure details