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

Multiple databases in a join

iaindowns posted 4 years ago in General
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
brazil posted 4 years ago
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.