desc文を使う。以下はumamusumeという自作のテーブルの構造を表示した例。
mysql> desc umamusume; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | no | int | NO | | NULL | | | name | varchar(20) | YES | | NULL | | | prizemoney | double | YES | | NULL | | | seiyu | varchar(20) | YES | | NULL | | | dummydate | date | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)