Structured query language — мова структурованих запитів
БД
Елементи SQL-запиту:
SELECT
DISTINCT
WHERE exists
AND, OR, NOT
ORDER BY
INSERT INTO
UPDATE
DELETE
SQL Injection
SELECT TOP (LIMIT)
LIKE
IN
BETWEEN
AS
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
UNION
SELECT INTO
INSERT INTO SELECT
CREATE DATABASE
CREATE TABLE
Constraints
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
CREATE INDEX
DROP
ALTER
AUTO INCREMENTR
VIEW
DATES
NULL Values
NULL Functions
Функції SQL
AVG()
COUNT()
FIRST()
LAST()
MAX()
MIN()
SUM()
GROUP BY
HAVING
UCASE()
LCASE()
MID()
LEN()
ROUND()
NOW()
FORMAT()
---------------
Складні випадки
tab1
SELECT Code
FROM tab1
WHERE Code > 5000;
-- коментар
/* коментар */
Порядок
1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
A_I - автозбільшення
Типи даних