distal-attribute
distal-attribute
distal-attribute
distal-attribute

Multiple databases in a join

User, date Message
Written by iaindowns
4 years ago
Category: General
1 posts since Tue, 01 Mar 11
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
Written by brazil
4 years ago
16 posts since Thu, 27 Jan 11
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.