[SQL] 基本 SQL 語法

1. SELECT
基礎：
SELECT * FROM {表格名}


2. INSERT INTO
基礎：
INSERT INTO {表格名} ( 欄位一, 欄位二, 欄位三 )
VALUES ( '{欄位一的值}', '{欄位二的值}', '{欄位三的值}' )

一階：
INSERT INTO {表格名} ( 欄位一, 欄位二, 欄位三 )
SELECT xxx1 AS 欄位一, xxx2 AS 欄位二, xxx3 AS 欄位三 FROM {表格名二}

3. UPDATE

UPDATE {表格名}
SET
{欄位一} = {欄位一的值},

{欄位二} = {欄位二的值}

WHERE {過濾條件}


4. DELETE
DELETE FROM {表格名}
WHERE {過濾條件}