[DML_INSERT] 데이터 삽입

INSERT

 

- 테이블에 새로운 행을 삽입

INSERT INTO Table [(Col1, COl2, Col3, ...)]
VALUES (Val1, Val2, Val3, ...);

 

INSERT INTO countries
VALUES ('KR', 'South Korea', 3);

INSERT INTO countries (country_id, country_name, region_id)
VALUES ('KP', 'North Korea', 3);

 

--SELECT *
--FROM departments;

INSERT INTO departments
VALUES (280, 'Testing', 200, 1700);

 

--SELECT *
--FROM departments;

INSERT INTO departments (department_id, department_name, location_id)
VALUES(290, 'Data Analytics', 1700);

--SELECT *
--FROM jobs;

INSERT INTO jobs
VALUES('IT DS', 'Data Scientist', 10000, 20000);

--SELECT *
--FROM jobs;

INSERT INTO jobs (job_id, job_title, min_salary, max_salary)
VALUES('IT DA', 'Data Analyst', 10000, 20000);

---

- DML 명령어를 최종적으로 반영하기 위한 방법

커밋 (F11) 아이콘 클릭(Transaction)