SQL

DML(Data Manipulation Language)

SELECT

• 基本

SELECT <COLUMN>,,, FROM <TABLE> WHERE <CONDITIONS>,,,

INSERT

• 基本

INSERT INTO <TABLE> (<COLUMN>,,,) VALUES (<VALUE>,,,);

• 複数レコードを一括挿入

INSERT INTO <TABLE> VALUES
    (<COL1_VALUE>, <COL2_VALUE>, <COL3_VALUE>,,, ),
    (<COL1_VALUE>, <COL2_VALUE>, <COL3_VALUE>,,, ),
    (<COL1_VALUE>, <COL2_VALUE>, <COL3_VALUE>,,, ),
    :

• SELECT文の結果をINSERT

-- TABLE2の検索結果をTABLE1へINSERT
INSERT INTO <TABLE1> SELECT ... FROM <TABLE2> WHERE ...

-- TABLE2の検索結果を列を指定してTABLE1へINSERT
INSERT INTO <TABLE1> (COLUMN, COLUMN, ...) SELECT ... FROM <TABLE2> WHERE ...

UPDATE

UPDATE <TABLE> SET <COLUMN> = <VALUE> WHERE 条件;

DELETE

DELETE FROM <TABLE> WHERE 条件;

REPLACE (MySQL)

REPLACE INTO <TABLE> (<COLUMN>,,, ) VALUES (<VALUE>) <SELECT>;

REPLACE INTO <TABLE> VALUES (VALUE1[, VALUE2, ...]);

• 参考資料:
  • MySQL :: MySQL 5.6 リファレンスマニュアル :: 13.2.8 REPLACE 構文

DDL(Data Definition Language)

CREATE

DROP

ALTER

TRUNCATE