Hiya,
How do I insert data from another database into a table?
Cheers
I believe you can do something like:
INSERT INTO database_1.table (col1, col2, col3) SELECT col1, col2, col3 FROM database_2.table_name