The INSERT statement

The INSERT INTO statement

-- listing specific columns
INSERT INTO table_name (column_1, column_2, ...)
VALUES (value_1, value_2,...);

-- all columns
INSERT INTO table_name 
VALUES (value_1, value_2,...);

The INSERT INTO - SELECT statement

-- listing specific columns
INSERT INTO table_name_duplicate (column_1, column_2, ...)
SELECT *
FROM table_name;

-- all columns
INSERT INTO table_name_duplicate 
SELECT *
FROM table_name;