Can you view MySQL data table structure in two ways?

Teach you how to view the data table structure

After we create the table , How to view the table structure , In order to confirm that the table meets our expectations , We can use describe perhaps show create table Order to see mysql Data table structure , Now let's look at the specific usage .

1、describe grammar

DESCRIBE/DESC Statement can view the field information of the table , This includes the field name 、 Field data type 、 Is it a primary key 、 Whether there are default values, etc .

grammar ：

DESCRIBE  Table name 

We usually abbreviate it as ：

DESC  Table name 

Let's take a look at the newly created table , Let's take a specific look at the content of each meaning ;

mysql> describe test_user;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| id     | int         | YES  |     | NULL    |       |
| name   | varchar(25) | YES  |     | NULL    |       |
| deptid | int         | YES  |     | NULL    |       |
| money  | float       | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc test_user;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| id     | int         | YES  |     | NULL    |       |
| name   | varchar(25) | YES  |     | NULL    |       |
| deptid | int         | YES  |     | NULL    |       |
| money  | float       | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>

We can see that no matter what we use describe still desc Command to view the table structure , The results are consistent .

Then look at the specific information ：

• Fiels： Field name

• Type： Field type

• Null： Whether it can be null

• Key： Is there an index ;PRI Indicates that it is part of the primary key ;UNI Indicates that the column is UNIQUE Part of index ;MUL Indicates that a given value is allowed to appear more than once

• Default： The default value is

• Extra： Represents additional information about a given column that can be obtained

2、show create table grammar

show create table You can view the specific statement of creating the table ;

grammar ：

show create table < Table name \G>

Use SHOW CREATE TABLE sentence , You can not only view the detailed statements when creating the table , You can also view the storage engine and character encoding .\G Parameters are equivalent to formatted output , Make its output content more readable .

Example ：

mysql> show create table test_user;
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table     | Create Table

                                                     |
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test_user | CREATE TABLE `test_user` (
  `id` int DEFAULT NULL COMMENT ' Employee number ',
  `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ' Employee name ',
  `deptid` int DEFAULT NULL COMMENT ' Department number ',
  `money` float DEFAULT NULL COMMENT ' Wages '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci                 |
+-----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

If you add \G after , We can see that the output content is highly readable ;

mysql> show create table test_user\G;
*************************** 1. row ***************************
       Table: test_user
Create Table: CREATE TABLE `test_user` (
  `id` int DEFAULT NULL COMMENT ' Employee number ',
  `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT ' Employee name ',
  `deptid` int DEFAULT NULL COMMENT ' Department number ',
  `money` float DEFAULT NULL COMMENT ' Wages '
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.00 sec)

ERROR:
No query specified

mysql>

Support , In this paper, the end .

For more information, go to VX official account “ Operation and maintenance home ” , Get the latest article .

------ “ Operation and maintenance home ” ------

------ “ Operation and maintenance home ” ------

------ “ Operation and maintenance home ” ------

Interview with system operation and maintenance engineer , Nominations for excellent staff of operation and maintenance engineer ,tr O & M Engineer , I'm calling the operation and maintenance engineer for daily work ,IT Senior operation and maintenance engineer ;
Intelligent manufacturing operation and maintenance engineer training course , Remote office operation and maintenance engineer , Salary of Mindray medical operation and maintenance engineer , What does the backstage O & M engineer do ;
How about the wind operation and maintenance engineer , Inspur cloud operation and maintenance engineer , Sample certificate of medical equipment operation and maintenance engineer , Boyfriend of operation and maintenance engineer , The O & M engineer is grumpy .