How to check the columns from a MySQL database table

January 07, 2025

There’s many way to check the columns names from a MySQL database table, frist using DESCRIBE Statement.

DESCRIBE table_name;

Other using the SHOW COLUMNS command.

SHOW COLUMNS FROM table_name;