詢記錄

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

    • 最新文章

    參觀人氣

    • 本日人氣：
    • 累積人氣：