Definition: The show columns MySQL command is used to display all the columns on a given table as well as any details about them. It is phrased as: show columns from table_name;
Examples:
show columns from new_cars;This would show all the columns and their information from the table 'new_cars'.
