SQL용어정리

Select
SELECT "필드명" FROM "도표명";

Distinct
SELECT DISTINCT "필드명"
FROM "도표명";

Where
SELECT "필드명"
FROM "도표명"
WHERE "조건";

And/Or
SELECT "필드명"
FROM "도표명"
WHERE "간단조건"
{[AND|OR] "간단조건"}+;

In
SELECT "필드명"
FROM "도표명"
WHERE "필드명" IN ('수치 1', '수치 2', ...);

Between
SELECT "필드명"
FROM "도표명"
WHERE "필드명" BETWEEN '수치 1' AND '수치 2';

Like
SELECT "필드명"
FROM "도표명"
WHERE "필드명" LIKE {양식};

Order By
SELECT "필드명"
FROM "도표명"
[WHERE "조건"]
ORDER BY "필드명" [ASC, DESC];

Count
SELECT COUNT("필드명")
FROM "도표명";

Group By
SELECT "필드명1", SUM("필드명2")
FROM "도표명"
GROUP BY "필드명1";

Having
SELECT "필드명1", SUM("필드명2")
FROM "도표명"
GROUP BY "필드명1"
HAVING (함수조건);

Create Table
CREATE TABLE "도표명"
("필드 1" "필드 1 데이터종류",
"필드 2" "필드 2 데이터종류",
... );

Drop Table
DROP TABLE "도표명";

Truncate Table
TRUNCATE TABLE "도표명";

Insert Into
INSERT INTO "도표명" ("필드 1", "필드 2", ...)
VALUES ("수치 1", "수치 2", ...);

Update
UPDATE "도표명"
SET "필드 1" = [수치]
WHERE "조건";

Delete From
DELETE FROM "도표명"
WHERE "조건";