| Oracle/MySQL 관련 게시판 |
|---|
| 2003/01/16(01:02) from 211.169.72.154 | |
| 작성자 : 강줄기 (jkkang65@hanmail.net) | 조회수 : 3380 , 줄수 : 41 |
| Re: [MySQL] CWS DB 구조 |
|---|
|
# mysql accnt_db mysql> show databases; accnt_db mysql> show tables from accnt_db accnt date username mysql> show columns from accnt; +--------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | user_name | char(20) | YES | | NULL | | | date | char(10) | YES | | NULL | | | cpu_time | int(11) | YES | | NULL | | | network_time | int(11) | YES | | NULL | | +--------------+----------+------+-----+---------+----------------+ mysql> show columns from date; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | date | char(10) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ mysql> show columns from username; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | date | char(10) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ |
|
|