Programming language:Whatever

insert select

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

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

WHERE condition;

Code: Whatever

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Code: Whatever


INSERT INTO table2

SELECT * FROM table1
WHERE condition;

Code: Whatever


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

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

WHERE condition;

New to Communities?