Składnia SQL

Mai multe ca aceasta

novopashinwm@gmail.com

după Vladimir Novopashin

Database

după Antonio Passos

Conceptos SQL

după Rafael Rojas

SQL LENGUAJE ESTRUCTURADO DE CONSULTAS

după favio gutierrez

Więcej na https://www.drmalinowski.edu.pl/

SQL Structured Query Language

TCL Transaction Control Language

RELEASE SAVEPOINT

SAVEPOINT

ROLLBACK

TO SAVEPOINT

COMMIT

DCL Data Control Language

REVOKE

GRANT

ALL PRIVILEGES

DML Data Manipulation Language

DELETE

FROM TABLE_NAME

UPDATE

WHERE CONDITION

SET COLUMN_NAME = VALUE

INSERT

VALUES(...)

INSERT INTO TABLE_NAME

DDL Data Definition Language

TRUNCATE

INDEX

DATABASE

ALTER

RENAME

MODIFY

DROP

ADD

CREATE

CONSTRAINTS

DEFAULT

CHECK

UNIQUE

FOREIGN KEY

PRIMARY KEY

VIEW

TABLE

DATABASE

Typy danych

TIMESTAMP

JSON

BOOLEAN

DATE

VARCHAR

INT

Funkcje agregujące

MAX()

MIN()

COUNT()

SUM()

AVG()

DQL Data Query Language

ALIAS

AS

ORDER BY

OFFSET

LIMIT

COLUMN DESC

COLUMN ASC

GROUP BY

HAVING

COLUMN_NAME

WHERE

Specjalne

EXISTS

ALL

ANY

IN

LIKE

BETWEEN

Logiczne

NOT

OR

AND

Operatory

IS NOT NULL

IS NULL

<, >, <=, >=, =

JOIN

CROSS JOIN

FULL JOIN

RIGHT JOIN

LEFT JOIN

INNER JOIN

FROM

TABLE(S)_NAME

SELECT

ALL TABLE(*)

COLUMN(S)