DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Arthur has posted 13 posts at DZone. View Full User Profile

SQL: Copy Data From One Table Into Another

07.19.2007
| 121511 views |
  • submit to reddit
        // SQL Query to copy data from one table and insert it into another

INSERT INTO TABLE2 (COL1, COL2, COL3) SELECT COL1, COL4, COL7 FROM TABLE1