Copy data from another table using INSERT

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 powered by Disqus