SQL Головна

2075 / Structured Query Language  —  мова структурованих запитів

 

Елементи запиту:

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

Функції

AVG()
COUNT()
FIRST()
LAST()
MAX()
MIN()
SUM()
GROUP BY
HAVING
UCASE()
LCASE()
MID()
LEN()
ROUND()
NOW()
FORMAT()
 

 

 

 

—————

 

 

 

 
 

 

Порядок

1. FROM
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY

A_I - автозбільшення

-- коментар
/* багаторядковий

коментар */