title: Mysql copy data from one database to another WHERE
body: <p>I am trying to copy data from one database into another. Essentially, I have 2 databases.</p>
  
  <ul>
  <li>Customer (which has ID, Name, DOB, Address)</li>
  <li>Full Customer (which has ID, PHOTO, SIGNATURE)(expanding to include Name, DOB, Address)</li>
  </ul>
  
  <p>All customers are stored in the Customer database (10 million records), but only some are stored in the "Full Customer" database. (5 million records).</p>
  
  <p>I want to copy all the Customer records into the Full Customer database where there is no record currently.</p>
  
  <p>My pseudo code is below for programming, but i am wondering if i can do this directly with mysql</p>
  
  <pre><code>for customer in customers:
      if customer.ID not in (select ID from fullcustomer)
          insert customer into fullcustomer
  </code></pre>