[Mariadb] table 상세 정보 보기
MariaDB [web3]> show full columns from 테이블명;
+--------------+----------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+--------------+----------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| no | int(11) | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | |
| date | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| temp | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| average_temp | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| tmn | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| tmx | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| weather | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| rainfall | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| month_day | char(20) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
+--------------+----------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
9 rows in set (0.00 sec)
MariaDB [web3]> describe weather_susin_myeon;
+--------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------+------+-----+---------+----------------+
| no | int(11) | NO | PRI | NULL | auto_increment |
| date | char(20) | YES | | NULL | |
| temp | char(20) | YES | | NULL | |
| average_temp | char(20) | YES | | NULL | |
| tmn | char(20) | YES | | NULL | |
| tmx | char(20) | YES | | NULL | |
| weather | char(20) | YES | | NULL | |
| rainfall | char(20) | YES | | NULL | |
| month_day | char(20) | YES | | NULL | |
+--------------+----------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
MariaDB [web6]> show create table weather_xml_test;
| Table | Create Table
+------------------+--------------------------------------------------------------------------------------------
| weather_xml_test | CREATE TABLE `weather_xml_test` (
`no` int(11) NOT NULL AUTO_INCREMENT,
`date` char(20) DEFAULT NULL,
`temp` char(20) DEFAULT NULL,
`average_temp` char(20) DEFAULT NULL,
`tmn` char(20) DEFAULT NULL,
`tmx` char(20) DEFAULT NULL,
`weather` char(20) DEFAULT NULL,
`rainfall` char(20) DEFAULT NULL,
`month_day` char(20) DEFAULT NULL,
PRIMARY KEY (`no`)
) ENGINE=InnoDB AUTO_INCREMENT=474 DEFAULT CHARSET=utf8 |
1 row in set (0.00 sec)