Select Particular column names from a table

Question

Possible Duplicate:
MySQL query to get column names?

I need to query the database to get the column/field names, not to be confused with data in the table. For example, if I have a table named wp_deals that contains deal_id, deal_price, creation_date then I would want to retrieve those field names from the query and nothing else.

so query should be like this

select column_names1,column_name2,column_name3 from table_name.

Be sure it should only gives those columns names that I want, not all.

Hint: `USE INFORMATION_SCHEMA; SHOW TABLES;` – Charles Jan 04 '13 at 07:50 — Charles, Jan 04 '13 at 07:50
you should usually know such information in advance – Jan 04 '13 at 07:51 — , Jan 04 '13 at 07:51

score 1 · Answer 1 · answered Jan 04 '13 at 07:53

1

Use the DESCRIBE command.

DESCRIBE `table_name`;

answered Jan 04 '13 at 07:53

alizahid

959
6
17

J.K.A. · Answer 2 · 2013-01-04T08:05:20.500

0

Do like this:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM INFORMATION_SCHEMA WHERE TABLE_NAME = 'my_table';

OR

SHOW columns FROM my-table;

http://dev.mysql.com/doc/refman/5.0/en/columns-table.html

edited Jan 04 '13 at 08:05

answered Jan 04 '13 at 07:51

J.K.A.

7,272
25
94
163

score 0 · Answer 3 · edited May 23 '17 at 10:24

0

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

Credits: @ ircmaxell

Reference: This Post

edited May 23 '17 at 10:24

Community

1
1

answered Jan 04 '13 at 07:51

Hanky Panky

46,730
8
72
95

i think it will work.it is the best answer.Let me try.. – Rana.Asif Jan 04 '13 at 10:10

Saharsh Shah · Answer 4 · 2013-01-04T14:40:43.357

0

Try this and check this link COLUMNS Table:

SELECT GROUP_CONCAT(COLUMN_NAME) 
FROM information_schema.COLUMNS 
WHERE TABLE_SCHEMA = 'dbName' AND TABLE_NAME = 'tableName';

edited Jan 04 '13 at 14:40

answered Jan 04 '13 at 07:53

Saharsh Shah

28,687
8
48
83

Select Particular column names from a table

4 Answers4