mysql查看表的字段信息
时间: 2023-10-16 21:14:49 浏览: 46
要查看MySQL表的字段信息,可以使用DESC命令或SHOW COLUMNS命令。以下是两种方法的示例:
1. DESC命令:
```
DESC table_name;
```
其中,table_name是要查看字段信息的表名。执行DESC命令后,将显示该表的所有字段的名称、类型、键信息和其他属性。例如:
```
DESC customers;
```
将显示类似以下内容的结果:
```
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| customer_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| first_name | varchar(45) | NO | | NULL | |
| last_name | varchar(45) | NO | | NULL | |
| email | varchar(50) | NO | UNI | NULL | |
+-------------+------------------+------+-----+---------+----------------+
```
2. SHOW COLUMNS命令:
```
SHOW COLUMNS FROM table_name;
```
与DESC命令类似,table_name是要查看字段信息的表名。执行SHOW COLUMNS命令后,将显示该表的所有字段的名称、类型、键信息和其他属性。例如:
```
SHOW COLUMNS FROM customers;
```
将显示类似以下内容的结果:
```
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| customer_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| first_name | varchar(45) | NO | | NULL | |
| last_name | varchar(45) | NO | | NULL | |
| email | varchar(50) | NO | UNI | NULL | |
+-------------+------------------+------+-----+---------+----------------+
```