MySQL DESC Command: Usage & Examples

DESC is a keyword in MySQL that is used to display the structure of a table, including the field names, data types, field length, and whether it is a primary key or not.

Example of use:

DESC table_name;

The table_name is the name of the table whose structure needs to be viewed.

After executing the above statement, MySQL will return a result set that contains information about the table’s columns.