- DESCRIBE; DESC, EXPLAIN
- MySQL 테이블 구조 보기, 테이블 구조 확인
1 실행예시 1[ | ]
MySQL
CPU
0.9s
MEM
23M
4.5s
Copy
DESC employee
+--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | LastName | varchar(20) | YES | | NULL | | | DepartmentID | int | YES | | NULL | | +--------------+-------------+------+-----+---------+-------+
MySQL
Copy
DESC Northwind.Category
Loading
2 실행예시 2[ | ]
Console
Copy
mysql> DESC wp_links;
+------------------+---------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------------------+----------------+
| link_id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| link_url | varchar(255) | NO | | | |
| link_name | varchar(255) | NO | | | |
| link_image | varchar(255) | NO | | | |
| link_target | varchar(25) | NO | | | |
| link_description | varchar(255) | NO | | | |
| link_visible | varchar(20) | NO | MUL | Y | |
| link_owner | bigint(20) unsigned | NO | | 1 | |
| link_rating | int(11) | NO | | 0 | |
| link_updated | datetime | NO | | 0000-00-00 00:00:00 | |
| link_rel | varchar(255) | NO | | | |
| link_notes | mediumtext | NO | | NULL | |
| link_rss | varchar(255) | NO | | | |
+------------------+---------------------+------+-----+---------------------+----------------+
3 실습[ | ]
Console
Copy
mysql> CREATE TABLE dept (
-> dept_no INT(11) unsigned NOT NULL,
-> dept_name VARCHAR(32) NOT NULL
-> );
Query OK, 0 rows affected (0.07 sec)
Console
Copy
mysql> DESC dept;
+-----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| dept_no | int(11) unsigned | NO | | NULL | |
| dept_name | varchar(32) | NO | | NULL | |
+-----------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
4 같이 보기[ | ]
- SHOW COLUMNS
- SHOW CREATE TABLE
- DESCRIBE
- MySQL 테이블 생성 쿼리 보기 SHOW CREATE TABLE
- MySQL 테이블 생성 CREATE TABLE
5 참고[ | ]
편집자 Jmnote Jmnote bot
로그인하시면 댓글을 쓸 수 있습니다.