Vidyalelo
MySQL · Q503

MySQL

Programming · MySQL · question 503

Q503

Which command is used for the table definition in Mysql?

A.
DESC table_name;
Answer
B.
DESC table_name
C.
DESC
D.
None of the mentioned

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about understanding how to see the structure of a table in MySQL. Think of it like looking at the blueprint of a house.

The command DESC is used to display the definition of a table. It shows you the columns, their data types, and other properties. This is helpful when you want to understand how a table is set up.

Let's break down the options:
Option A: DESC table_name; This is the correct syntax. You use "DESC" followed by the name of your table and a semicolon at the end.
Option B: DESC table_name This is missing the semicolon, which is needed to complete the command in MySQL.
Option C: DESC This is incomplete. It needs the table name after "DESC".
Option D: None of the mentioned This is incorrect because Option A is the correct command.

So the answer is Option A: DESC table_name;