DML

DML(Data Manipulation Language)

데이터 조작 언어로 테이블에 값을 삽입(INSERT), 수정(UPDATE),
삭제(DELETE)하는 구문을 말함

 

INSERT

테이블에 새로운 행을 추가하여 테이블의 행 개수를 증가시키는 구문

INSERT INTO [테이블명]

VALUES(  ,  ,  ,  ,  );

UPDATE

테이블에 기록된 컬럼 값을 수정하는 구문으로 테이블 전체 행 개수는 변화 없음

UPDATE [테이블]

SET [컬럼명] = [변경할값]

WHERE 조건절~

 

DELETE

테이블의 행을 삭제하는 구문으로 테이블의 행 개수가 줄어듦

DELETE FROM [테이블]

WHERE 조건절~

 

삭제 시 FOREIGN KEY 제약조건으로 컬럼 삭제가 불가능한 경우
제약조건을 비활성화 할 수 있음

 

예) 

ALTER TABLE EMPLOYEE
DISABLE CONSTRAINT EMP_DEPTCODE_FK CASCADE;

 

INSERT INTO EMPLOYEE
VALUES(1, ‘홍길동’, ‘820114-1010101’, ‘hong_kd@kh.or.kr’, ‘01099998888’, ‘D5’, ‘J2’, ‘S4’, 3800000,
NULL, ‘200’, SYSDATE, NULL, DEFAULT);

UPDATE EMPLOYEE
SET EMP_ID = 290
WHERE EMP_NAME = ‘홍길동’;

DELETE FROM EMPLOYEE
WHERE EMP_NAME = ‘홍길동’;