SQL語法－FIVE｜痞客邦

Feb 27 Sun 2005 10:27
SQL語法

詢記錄

SELECT [DISTINCT]

FROM

{{,

{}}

[WHERE ]

[GROUP BY [HAVING ]]

[ORDER BY []{,[]}]

::= *|(|(([DISTINCT]|*)))

　{,(|(([DISTINCT]|*))})

::={,}

::= ASC | DESC

範例：從資料檔中找出第3次作業分數大於60分的全部記錄，且依學號由小到大排序。

SELECT *

FROM "pub.demo.homework"

WHERE score > 60

ORDER BY id ASC

增加記錄

INSERT INTO

[({,})]

VALUES ( ,{})|

[WHERE

範例：刪除學生1234567的所有記錄

DELETE FROM "pub.demo.homework"

WHERE id like '1234567'

更改記錄

UPDATE

SET = {, = }

[WHERE