How to show field of a table in mysql?

Question

show fields from table_name
and
show columns from table_name

shows Fields, Type,Null,Key,Default,Extra

But, I want to show only Fields so that I can copy field's name to use another(e.g. inserting data or making csv file because csv file need to have column name in 1st row).

What is the command to view this?

score 0 · Accepted Answer · answered Mar 30 '18 at 06:13

0

SELECT column_name
FROM information_schema.columns
WHERE  table_name = 'your_table'
AND table_schema = 'database_name'

answered Mar 30 '18 at 06:13

Arunkumar Muthuvel

423
3
18

Please don't answer duplicates if possible. – Tim Biegeleisen Mar 30 '18 at 06:16

How to show field of a table in mysql?

1 Answers1