mysql show table fields

1SHOW COLUMNS FROM mydb.mytable;

1SELECT COLUMN_NAME
2  FROM INFORMATION_SCHEMA.COLUMNS
3  WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';
4

1DESCRIBE table_name; # To show table structure...

1DESCRIBE my_table;
2

1Copied mysql> DESCRIBE pet;
2+---------+-------------+------+-----+---------+-------+
3| Field   | Type        | Null | Key | Default | Extra |
4+---------+-------------+------+-----+---------+-------+
5| name    | varchar(20) | YES  |     | NULL    |       |
6| owner   | varchar(20) | YES  |     | NULL    |       |
7| species | varchar(20) | YES  |     | NULL    |       |
8| sex     | char(1)     | YES  |     | NULL    |       |
9| birth   | date        | YES  |     | NULL    |       |
10| death   | date        | YES  |     | NULL    |       |
11+---------+-------------+------+-----+---------+-------+