SELECT Command

 SELECT command is very important command in MySQL. This command is use to print or display data based on certain conditions. the syntax command has the following syntax.

SELECT <Column Names>,<Column Names>,<Column Names>,<Column Names>

FROM <TableName>

WHERE <Conditions>

ORDER BY <<Column Names> ASC / DESC

GROUP BY <Column Names> HAVING <Conditions>

 

This command has many options to write, 

but this section is compulsory 

SELECT <Column Names>,<Column Names>,<Column Names>,<Column Names>

FROM <TableName>

and all other section of SELECT command is optional 

We will learn all the sections one by one with example.

EXAMPLE Table Structure with data: