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

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

Syntax

EXPLAIN table_name col_name;

Example1

mysql> EXPLAIN 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> EXPLAIN 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’.

Prabhas

Published on 21-Feb-2018 17:44:14