How to find the name of a column in MySQL?

For this, you can use SHOW COLUMNS or INFORMATION_SCHEMA.COLUMN.

Let us first create a table −

mysql> create table DemoTable603    (       ClientId int NOT NULL AUTO_INCREMENT,       ClientName varchar(100),       ClientAge int,       ClientAddress varchar(100),       ClientCountryName varchar(100),       ClientEducationDetails varchar(200),       PRIMARY KEY(ClientId)    ); Query OK, 0 rows affected (0.59 sec)

CASE 1 − Using SHOW command

Here is the query to find the name of a column in MySQL −

mysql> SHOW COLUMNS FROM DemoTable603;

This will produce the following output −

+------------------------+--------------+------+-----+---------+----------------+ | Field                  | Type         | Null | Key | Default | Extra          | +------------------------+--------------+------+-----+---------+----------------+ | ClientId               | int(11)      | NO   | PRI | NULL | auto_increment | | ClientName             | varchar(100) | YES  |     | NULL | | | ClientAge              | int(11)      | YES  |     | NULL | | | ClientAddress          | varchar(100) | YES  |     | NULL | | | ClientCountryName      | varchar(100) | YES  | | NULL | | | ClientEducationDetails | varchar(200) | YES  | | NULL | | +------------------------+--------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec)

CASE 2 − Using information_schema.column −

mysql> select column_name from information_schema.columns where table_schema='web' and table_name='DemoTable603';

This will produce the following output −

+------------------------+ | COLUMN_NAME            | +------------------------+ | ClientAddress          | | ClientAge              | | ClientCountryName      | | ClientEducationDetails | | ClientId             | | ClientName             | +------------------------+ 6 rows in set (0.00 sec)