How do you list all fields from one table in MySQL?

 To list all fields (columns) from a table in MySQL, you can use one of the following methods:

1. Using DESCRIBE or EXPLAIN Statement

DESCRIBE table_name;

or

EXPLAIN table_name;

This will provide details about each column in the table, including its name, data type, whether it allows NULL, and other information.

---

2. Using SHOW COLUMNS Statement

SHOW COLUMNS FROM table_name;

This will return the column names along with their types, nullability, key information, default values, and extra information.

---

3. Querying the Information Schema

The INFORMATION_SCHEMA.COLUMNS table contains metadata about all columns in the database.

To get just the column names for a specific table:

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table_name'
  AND TABLE_SCHEMA = 'database_name';

Replace table_name with the name of your table and database_name with the name of your database.

---

Choosing the Right Method

• For a quick overview, use DESCRIBE or SHOW COLUMNS.
• For more flexibility (e.g., filtering by schema or table name), use the INFORMATION_SCHEMA.COLUMNS query.