How Can I Retrieve MySQL Table Column Names in PHP?

Extracting Table Column Names in MySQL

In PHP, there are multiple methods to retrieve the names of columns in a MySQL table:

1. DESCRIBE

The DESCRIBE command provides a detailed description of a table, including column names:

DESCRIBE my_table;

2. INFORMATION_SCHEMA

MySQL's INFORMATION_SCHEMA system database contains data about database objects. To retrieve column names using this method:

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

3. SHOW COLUMNS

Another alternative is the SHOW COLUMNS command:

SHOW COLUMNS FROM my_table;

4. Grouped Concatenation

To obtain column names separated by commas in a single line:

SELECT group_concat(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

The above is the detailed content of How Can I Retrieve MySQL Table Column Names in PHP?. For more information, please follow other related articles on the PHP Chinese website!