Multiple databases in a join

[expired user #5564]'s profile image [expired user #5564] posted 13 years ago in General Permalink
I know I can have multiple databases open at once in heidi, but can I use more than one in a sql query? I want to update the contents of one database based on the contents of another (on a different machine).

I can't work out what the syntax would be.

Thanks

Iain
[expired user #5483]'s profile image [expired user #5483] posted 13 years ago Permalink
So, that's not only a different DB but a different server! MySQL syntax does not allow addressing a server in a table reference, see http://dev.mysql.com/doc/refman/5.1/en/select.html#id841292

Please login to leave a reply, or register at first.