INSERT Statement
Used to add new rows to a table.
INSERT INTO employees (employee_id, first_name, salary)
VALUES (101, 'John', 5000);You can also insert using subqueries:
INSERT INTO employees (employee_id, first_name, salary)
SELECT employee_id, first_name, salary FROM employees_backup;