意外にも探すの手間取ったのでメモー
mysql> show full columns from table_name;
table_name
を任意に書き換えてくださーい。でわー。
ついでに結果も。。。
mysql> show full columns from tektiou_table; +--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+--------------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+--------------+ | id | int(11) | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | ID | | tekitou_no | varchar(20) | utf8_general_ci | NO | | NULL | | select,insert,update,references | 適当ID | | creater_id | int(11) | NULL | YES | | NULL | | select,insert,update,references | 作成者 | | modifier_id | int(11) | NULL | YES | | NULL | | select,insert,update,references | 更新者 | | created | datetime | NULL | NO | | NULL | | select,insert,update,references | 作成日 | | modified | datetime | NULL | NO | | NULL | | select,insert,update,references | 更新日 | +--------------+-------------+-----------------+------+-----+---------+----------------+---------------------------------+--------------+ 6 rows in set (0.00 sec)