How to see table’s field formats or description of table

by

mysql> describe tablename;

In MySQL, you can use the DESC or DESCRIBE statement to see the description of a table, including the field formats. Here’s an example:

sql
DESCRIBE your_table_name;

or

sql
DESC your_table_name;

Replace “your_table_name” with the actual name of the table you want to describe. This will provide information about the columns, their data types, whether they allow NULL values, and any additional attributes.

For example:

sql
DESCRIBE employees;

This will show you the structure and details of the “employees” table.