mysql数据库操作之查看表结构
语法代码:
案例运行代码:
- -- 方法一
- mysql> describe stu2;
- +-------+-------------+------+-----+----------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+-------------+------+-----+----------+----------------+
- | id | int(11) | NO | PRI | NULL | auto_increment |
- | name | varchar(20) | NO | | NULL | |
- | add | varchar(50) | NO | | 地址不详 | |
- | score | int(11) | YES | | NULL | |
- +-------+-------------+------+-----+----------+----------------+
- 4 rows in set (0.05 sec)
- -- 方法二
- mysql> desc stu2;
- +-------+-------------+------+-----+----------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +-------+-------------+------+-----+----------+----------------+
- | id | int(11) | NO | PRI | NULL | auto_increment |
- | name | varchar(20) | NO | | NULL | |
- | add | varchar(50) | NO | | 地址不详 | |
- | score | int(11) | YES | | NULL | |
- +-------+-------------+------+-----+----------+----------------+
- 4 rows in set (0.00 sec)
复制代码
|
|