insert into select
snippet in sql

insert into select

user961

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...
 FROM table1

WHERE condition; 

insert into select

user3247


INSERT INTO table2

SELECT * FROM table1
WHERE condition; 

insert into select

user1829


INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...
 FROM table1

WHERE condition; 

INSERT INTO SELECT

user7821


INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...
 FROM table1

WHERE condition; 

INSERT INTO SELECT

user8916


INSERT INTO table2

SELECT * FROM table1
WHERE condition;