sql - Gakgu/Gakgu.github.io GitHub Wiki

DDL(Data Definition Language)

CREATE

  CREATE DATABASE <database name>
  CREATE TABLE <table name>
  CREATE VIEW <view name> AS <SELECT절>

DROP

  DROP DATABASE <database name>
  DROP TABLE <table name>
  DROP VIEW <view name>

ALTER

  ALTER TABLE <old table name> RENAME TO <new table name>;

DML(Data Manipulation Language)

INSERT

  INSERT INTO table(name, age) VALUES("gakgu", 29);

UPDATE

  UPDATE table SET age = 30 WHERE name == "gakgu";

DELETE

  DELETE FROM table where name = gakgu;