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