title: Insert INTO MySQL FROM another table
body: <pre><code>INSERT INTO campaign_ledger (`campaign_id`, `description`, amount, balance, timestamp)
  VALUES (SELECT id as campaign_id, 'Ported from campaigns' as description, budget_remaining as amount, budget_remaining as balance, NOW() as timestamp FROM campaigns)
  </code></pre>
  
  <p>That's my syntax, but I get an error saying:</p>
  
  <blockquote>
    <p>You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near 'SELECT id as campaign_id, 'Ported from campaigns' as
    description, budget_remaini' at line 2</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>