Reference: Keywords
-
SELECT
Used to select data in tables.
INSERT
Used to insert rows and data in tables.
UPDATE
Used to modify exsisting data in tables.
DELETE
Used to delete rows from tables.
FROM
Used to select where the data will be searched in.
WHERE
Used to filter results based on conditions.
ORDER BY
Used to order the results in ascending it descending order.
CREATE
Used to create objects like tables or databases.
ALTER
Used to select a table and modify it.
COUNT
Returns the number of results for a query.
MAX
Returns the maximal value of a column.
MIN
Opposite of MAX; returns the minimal value of a column.