title: MySQL: SELECT from another server
body: <p>I'm afraid that I already know the answer to my question, but I'll ask it anyway:</p>
  
  <p>When there are two MySQL DB servers, can I access data that is stored on the other server? </p>
  
  <p>In other words: Can I somehow do this:</p>
  
  <pre><code>INSERT INTO table (x, y, z)
     SELECT x, y, x+y
        FROM [otherserver].[database].[table]
  </code></pre>
  
  <p>Is the answer really as short as "No"?</p>