Home
Blog
Copy data from another table using INSERT

Copy data from another table using INSERT

September 20, 2010 SQL Snippet 
INSERT INTO MyDestinationTable (MyField1, MyField2, MyField3)
SELECT MyField1, MyField2, MyField3 FROM MySourceTable
If your two tables have the exact same structure you may omit the list of columns in both the INSERT and SELECT sub statements, but it doesn't hurt to be explicit.

Related posts:

Comments

comments powered by Disqus
This website uses cookies to ensure you get the best experience on our website
Got it!