INSERT
INSERT INTO salesRep_employee_1
SELECT employeeId, firstName, lastName, email, jobTitle
FROM employees
WHERE jobTitle = 'Sales Rep'
SELECT *
FROM salesRep_employee_1
employees 테이블에서 로우 가져와 salesRep_employee_1 테이블에 로우 삽입
CTAS
CREATE TABLE salesRep_employee_2 AS
SELECT employeeId, firstName, lastName, email, jobTitle
FROM employees
WHERE jobTitle = 'Sales Rep';
SELECT *
FROM salesRep_employee_2;
DELETE
Safes-update mode(in MySQL)