Examveda

In the following SQL command "*" stands for?
SELECT * FROM person;

A. Retrieve all data from the table

B. Retrieve data of primary key only

C. Retrieve NULL data

D. None of the mentioned

Answer: Option A

Solution (By Examveda Team)

This question asks about the meaning of the asterisk (*) symbol in a SQL query.
Let's break down the query:
SELECT * FROM person;

* SELECT: This keyword tells the database you want to retrieve data.
* FROM person: This tells the database which table to get the data from (in this case, a table called "person").
* * : This is where the asterisk comes in. It's a wildcard symbol.

So, what does the asterisk mean?
It means you want to retrieve all the columns (data fields) from the "person" table.

Therefore, the correct answer is Option A: Retrieve all data from the table.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous