The syntax of the mysql for returning columns of a specific table is

SHOW COLUMNS
  FROM tbl_name
  [FROM db_name]
  [LIKE wild]
[download]

But if you want to get all columns from all tables in mysql (in this example with the table it was found in to the left):

SELECT table_name, column_name
  FROM information_schema.columns
[download]