Friday, July 13, 2018

Sql insert into copy data one table to another table


SQL insert into statement use for insert old record into new tables. Is an easy query , you can insert large table data in a single query . It’s helps to copy one table data to another.


Query:

INSERT INTO TableName1 (column1, column2)
SELECT column1, column2
FROM TableName2
WHERE condition

No comments:

Post a Comment