Insert Into

•Insert a new row containing values for each column
•List values must be the same of list of columns in the table

Insert into departments (department_id, department_name, manager_id, location_id)
Values
(99, ‘Online Sales’, 999, 9999);



Auto Insert Into
Insert into departments
Values
(‘&department_id’, ‘&department_name’, ‘&manager_id’, ‘&location_id’);