The DESCRIBE command is an invaluable debugging aid when you need to ensure that you have correctly created a MySQL table. You can also use it to remind yourself about a table’s field or column names and the types of data in each one. Let’s look at each of the headings in detail:

Field
The name of each field or column within a table
Type
The type of data being stored in the field
Null
Whether the field is allowed to contain a value of NULL
Key
What type of key, if any, has been applied (keys or indexes in MySQL are quick
ways to look up and search for data)
Default
The default value that will be assigned to the field if no value is specified when a new row is created
Extra
Additional information, such as whether a field is set to auto-increment

Command is: DESCRIBE classics;