정보처리기사 - SQL 문법 정리

DaY·2021년 4월 19일
2

정보처리기사

목록 보기
32/33
post-thumbnail

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 - 1
ALTER TABLE … DROP COLUMN …

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

0개의 댓글