Which command is used for the table definition in Mysql?
A. DESC table_name;
B. DESC table_name
C. DESC
D. None of the mentioned
Answer: Option A
Solution(By Examveda Team)
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;
Join The Discussion