mysql> DESCRIBE pocus; +-----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+-------+ | chr | varchar(5) | YES | | NULL | | | start | int(10) unsigned | YES | | NULL | | | stop | int(10) unsigned | YES | | NULL | | | gene_name | varchar(15) | YES | | NULL | | | score | float(6,3) unsigned | YES | | NULL | | | strand | char(1) | YES | | NULL | | +-----------+---------------------+------+-----+---------+-------+ 6 rows in set (0.00 sec)