SQL 문법 정리

SELECT

BETWEEN A AND D != IN( A, B, C, D)

INSERT

INSERT INTO (table name) VALUES(…) ;

UPDATE

UPDATE (table name) SET (update content) WHERE (conditions) ;ALTER TABLE (table name) ADD((update content)) ;ALTER TABLE (table name) MODIFY((update content)) ;ALTER TABLE (table name) DROP COLUMN((column name)) ;

CREATE

CREATE VIEW (view name) AS (select …) ;CREATE INDEX (index name) ON (index content) ;

GRANT

GRANT SELECT, INSERT, UPDATE, DELETE ON (table name) TO (user name) WITH GRANT OPTION ;REVOKE SELECT, INSERT, UPDATE, DELETE ON (table name) FROM (user name) CASCADE CONSTRAINTS ;

DELETE

DELETE FROM (table name) WHERE (conditions) ;DROP TABLE (table name) CASCADE CONSTRAINTS ;

DELETE COLUMN / ATTRIBUTE / DEGREE - 1ALTER TABLE … DROP COLUMN …

DELETE ROW / TUPLE /CARDINALITY - 1DELETE FROM … WHERE …