Inserting Data from Another Table

Inserting Data from Another Table

INSERT INTO employees_archive (id, first_name, last_name, email) SELECT id, first_name, last_name, email FROM employees WHERE hire_date < '2023-01-01';

You can also insert data into a table from another table using a SELECT statement.

Related concepts

→
Inserting Data from Another Table

Inserting Data from Another Table — Structure map

Clickable & Draggable!

Inserting Data from Another Table — Related pages:

SQL Insert