Get column names from table in MySql > 5

The following query will get column names from table in MySql > 5

where

  • database_name is your database
  • table_name is your table