Składnia SQL

Ver más

Conceptos SQL

por Rafael Rojas

Sql server 2019

por Ali varzeshi

iBatis Data Mapper 2.0

por aakarsh nair

小工具運用說明

por tsraeb t

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)