MYSQL CLAUSES...
MySQL system clauses are keywords or statements to handle information. It helps to operate a group of the data and apply it to require conditions. The clauses apply conditions or select patterns to get information. MySQL clauses are not used to insert new data. You retrieve data using several clauses.
Clauses in MYSQL as below
- WHERE clause : This clause uses a condition to retrieve and delete data.
- FROM clause : This clause works with a pattern to display the table and its value.
- ORDER BY clause : It helps to show data in ascending or descending order.
- GROUP BY clause : This clause displays information in a particular group.
- HAVING clause : This clause applies after the "group by" clause.
- DISTINCT clause : It removes the duplicate information of the table.
- LIMIT clause : This clause helps to assign a limit to the table data.
Syntax :
The MySQL clauses syntax is below. This syntax shows several MySQL clauses with conditions.
SELECT column1, column2, ..., columnN
FROM table-name
WHERE condition
GROUP BY column1, column2, ..., columnN
HAVING column regex value (condition);
ORDER BY expression [ASC] | [DES];