How can I get the information about a particular column of a table by MySQL DESCRIBE statement?

As we know that DESCRIBE statement will provide the information/structure of the whole table. With the help of DESCRIBE statement along with table name and the column name, we can get the information about that column.

Syntax

DESCRIBE table_name col_name;

Example1

mysql> Describe employee ID;
+-------+---------+------+-----+---------+----------------+
| Field | Type    | Null | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| ID    | int(11) | NO   | PRI | NULL    | auto_increment |
+-------+---------+------+-----+---------+----------------+
1 row in set (0.11 sec)

The query above will give the information about the column ‘ID’ of a table named ‘employee’.

Example2

mysql> Describe employee name;
+-------+-------------+------+-----+---------+---------+
| Field | Type        | Null | Key | Default | Extra   |
+-------+-------------+------+-----+---------+---------+
| Name  | varchar(20) | YES  |     | NULL    |         |
+-------+-------------+------+-----+---------+---------+
1 row in set (0.03 sec)

The query above will give the information about the other column ‘Name’ of a table named ‘employee'.

Radhakrishna

Published on 21-Feb-2018 12:59:18

• Related Questions & Answers
• How can I get the information about a particular column of a table by MySQL EXPLAIN statement? EXPLAIN statement?
• How we can get more information about columns of a table than the information we got by DESCRIBE, EXPLAIN and SHOW COLUMNS MySQL statements?
• What kind of information is displayed by MySQL DESCRIBE statement?
• How can I describe all tables in the database through a single statement in MySQL?
• How can I get the records from MySQL table in result set in a particular way?
• How can we get more details about columns of an existing table than return by MySQL SHOW COLUMNS statement?
• How can I see the CREATE TABLE statement of an existing MySQL table?
• How can I use MySQL INTERVAL() function with a column of a table?
• How can I change the name of an existing column from a MySQL table?
• How can we update MySQL table after removing a particular string from the values of column?
• How can I drop an existing column from a MySQL table?
• How can I remove every column in a table in MySQL?
• Get the number of rows in a particular table with MySQL
• How do I get the creation date of a MySQL table?
• Can I get the count of repeated values in a column with MySQL?