How will you see the structure of a table in MySQL?

We can use DESC query to see the structure of a table in MySQL. It will return the name of columns and their datatype in a table.

Query is as follows:

DESC

<

table>;

Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*