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
Multiple databases in a join
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.