Select

SELECT "column_name" FROM "table_name"

 

Distinct

SELECT DISTINCT "column_name"

FROM "table_name"

 

Where

SELECT "column_name"

FROM "table_name"

WHERE "condition"

 

And/Or

SELECT "column_name"

FROM "table_name"

WHERE "simple condition"

{[AND|OR] "simple condition"}+

 

In

SELECT "column_name"

FROM "table_name"

WHERE "column_name" IN ('value1', 'value2', ...)

 

Between

SELECT "column_name"

FROM "table_name"

WHERE "column_name" BETWEEN 'value1' AND 'value2'

 

Like

SELECT "column_name"

FROM "table_name"

WHERE "column_name" LIKE {PATTERN}

 

Order By

SELECT "column_name"

FROM "table_name"

[WHERE "condition"]

ORDER BY "column_name" [ASC, DESC]

 

Count

SELECT COUNT("column_name")

FROM "table_name"

 

Group By

SELECT "column_name1", SUM("column_name2")

FROM "table_name"

GROUP BY "column_name1"

 

Having

SELECT "column_name1", SUM("column_name2")

FROM "table_name"

GROUP BY "column_name1"

HAVING (arithematic function condition)

 

Create Table

CREATE TABLE "table_name"

("column 1" "data_type_for_column_1",

"column 2" "data_type_for_column_2",

... )

 

Drop Table

DROP TABLE "table_name"

 

Truncate Table

TRUNCATE TABLE "table_name"

 

Insert Into

INSERT INTO "table_name" ("column1", "column2", ...)

VALUES ("value1", "value2", ...)

 

Update

UPDATE "table_name"

SET "column_1" = [new value]

WHERE {condition}

 

Delete From

DELETE FROM "table_name"

WHERE {condition}

تعریف های اولیه :

Query : به معنای درخواست است و در sql به کد جستجویی می گویند که شما برای بدست آوردن نتیجه ای آن را مینویسید و اجرا می کنید .

Resault set : نتیجه بدست آمده از یک Query را میگویند.

Database : پایگاه داده را دیتابیس میگویند که میتواند شامل جداول و ماژول های ما باشد

بزودي تمامي کد هاي بالا را در دروس مختلف مي آموزيد .