Copying Table Rows

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.

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


Recent Articles: