How to find column name in MySQL?

Question

How to get the column name? What is the request for this?

Thank.

Answer 1

SHOW COLUMNS command can be used to retrieve column names in a table

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

Answer 2

You can use SHOW COLUMNS , which displays information about the columns in this table.

Answer 3

DESCRIBE tableName will give you the names of all the columns in the table.

Answer 4

This is a fairly broad context.

You can try something as simple as

describe `table_name`;