What is INSERT INTO SELECT
The INSERT INTO SELECT statement copies data from one table and inserts it into another table.
INSERT INTO SELECT requires that data types in source and target tables match
The existing records in the target table are unaffected
Example:
INSERT INTO table2
SELECT * FROM table1
WHERE condition;
The INSERT INTO SELECT statement copies data from one table and inserts it into another table.
INSERT INTO SELECT requires that data types in source and target tables match
The existing records in the target table are unaffected
Example:
INSERT INTO table2
SELECT * FROM table1
WHERE condition;
No comments:
Post a Comment