SQL

Елементи 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 - автозбільшення

Типи даних