Search notes:

SQL: INSERT statement

The purpose of the insert statement is to add data (that is: create new records) to a table.

Insert a single record into a table

INSERT INTO target_table                VALUES (1, 'one');
INSERT INTO target_table (col_1, col_2) VALUES (2, 'two');

The individual records to be inserted can be separated with commas:

INSERT INTO target_table VALUES
('record'    , 'one'   ),
('another'   , 'record'),
 …;

Note, that this variant does not work with Oracle SQL (18c).

The result of a select statement can be inserted into a table:

INSERT INTO target_table
  SELECT …
  FROM   …
;