MySQL

Select column1, column2, FROM table

Reads data from a table

WHERE

an if to select data only where a specific condition is met

SELECT costumername FROM customers

WHERE country=mexico

AND, OR, NOT

AND (‘x’ OR ‘x’)

ORDER BY Column ASC|DESC

INSERT INTO Table (Column, Column)

VALUES (value, value)

Inserts a row into the columns of a table, if no column is selected, it inserts into all the columns. The order of the values should match the order of the columns.