How to get columns of an existing table in MySQL?

I want to get columns of my existing table in MySQL database. Is there any command in the MySQL that may help me to show columns of an existing table?

You can get columns of an existing table using MySQL SHOW COLUMNS statement. Take an example, this will show you columns of your existing table:

SHOW COLUMNS FROM table_name;

Also, you can use MySQL DESCRIBE command. The DESCRIBE command is a shortcut for the SHOW COLUMNS command and identical to SHOW COLUMNS FROM table_name. Take another example:

DESCRIBE table_name;