Hello.
Can I select from one db and insert into another?
Yes. For example:
insert into test2.t2 select a from test.t2;
We insert values from table t2 of the database test into table t2
of the test2 database. See:
http://dev.mysql.com/doc/mysql/en/identifier-qualifiers.html
[snip]
Can I select from one db and insert into another?
also...Can I join to a remote db?
[/snip]
Yes, if you can share the connection. Consider...
INSERT INTO db1.tableI (`stuff`)
SELECT `stuff`
FROM db2.tableII
Doing a join to a remote database is not possible as you would have to
have two