DESCRIBE `tablename`;
# returns the following information:
# Field
# Type
# Null
# Key
# Default
# Extra

# if you need the Comment as well:

SHOW FULL COLUMNS FROM `tablename`;
# returns the following information:
# Field
# Type
# Collation
# Null
# Key
# Default
# Extra
# Privileges
# Comment