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)
Published on 22-Aug-2019 12:48:51
