INSERT SELECT possible from one DB to another?

Databases
1

I can successfully do an insert select from one table to another in the same database. Is it possible to do this from one database to another?

Thanks!

2

what happened when you tested it?

and which database system are you using?

3

The insert select worked fine when I used two tables within the same database. But I’m not even sure how to tweak it so that it spans across two separate databases.

Thanks!

4

if you wouldn’t mind posting this query, i can show you how to tweak it

5

Ok, here it is:

insert into communications (dateAdded, uID, type, entry)
select registerDate, uID, ‘General Note’, ‘Requested info about silver coins during registration.’
from users where wantSilver = ‘Yes’ and registerDate > ‘2011-02-20 09:34:00’;

6

insert into database1.communications (dateAdded, uID, type, entry)
select registerDate, uID, ‘General Note’, ‘Requested info about silver coins during registration.’
from database2.users where wantSilver = ‘Yes’ and registerDate > ‘2011-02-20 09:34:00’;

this is how you do it in most database systems, with minor variations

(you never did mention which database system you’re using)