The SQL INSERT INTO SELECT Statement

Question

Manish Kumar · Answer

It copies data from one table and paste it into another table.and INSERT INTO SELECT requires same data types in source and target tables match
The existing records in the target table are unaffected
INSERT INTO SELECT Syntax
Copy all columns from one table and paste into another table:
INSERT INTO table2
SELECT * FROM table1
WHERE condition;
Copy only some columns from one table and paste into another table:
INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

interview

The SQL INSERT INTO SELECT Statement

Manish Kumar

Can you answer this question?

1 Answers

INSERT INTO SELECT Syntax

Liked By