How to get only name of columns in mysql table?

@adan 

To get the names of columns in a MySQL table, you can use the "DESCRIBE" statement or query the "INFORMATION_SCHEMA" database. Here are two approaches:

1. Using the DESCRIBE statement:

1

DESCRIBE table_name;

Replace "table_name" with the actual name of the table whose columns you want to retrieve. This statement will return a result set with columns such as "Field", "Type", "Null", "Key", "Default", "Extra".

1. Querying the INFORMATION_SCHEMA database:

1
2
3
4

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'your_table_name'
    AND TABLE_SCHEMA = 'your_database_name';

Replace "your_table_name" with the actual name of the table you want to retrieve column names from, and "your_database_name" with the name of your MySQL database. This query will return only the column names.

Both approaches can be used depending on your specific needs.