テーブルのフィールド一覧を表示する
show fields
mysql> use 2555_development Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show fields from items; +-------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | itemName | varchar(255) | NO | | | | | itemCode | varchar(255) | NO | | | | : : | created_at | datetime | YES | | NULL | | | updated_at | datetime | YES | | NULL | | +-------------------+--------------+------+-----+---------+----------------+ 26 rows in set (0.01 sec)
使うDBを指定してから「show fields」すること。