SQL - Syntax for SQL sentences to INSERT INTO and SELECT

Syntax for: SQL sentences to INSERT INTO and SELECT

All columns

INSERT INTO table_name1
    SELECT * FROM table_name2;

Some Columns

INSERT INTO table_name1 (column_name1, column_name2)
    SELECT column_name1, column_name2 FROM table_name2;