Copying Table Rows

Question:
I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables have the same structure.

Answer:
Use this:

SELECT xxx from table1 INSERT into table2 WHERE blah-blah-blah

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: