title: mysql error: ERROR 1241 (21000): Operand should contain 1 column(s)
body: <p>I am facing an issue with a mysql query. I need to copy data from one table to another table. The query I am using is:</p>
  
  <p><code>mysql&gt; insert into voucher (code, amount, expire_at, state, driver_id, asset_account_id, created_at, updated_at, creator_id, agent, voucher_batch_id, image, city_id, country_id, serial_number, updater_id, redeemed_at) select (code, amount, expire_at, state, driver_id, asset_account_id, created_at, updated_at, creator_id, agent, voucher_batch_id, image, city_id, country_id, serial_number, updater_id, redeemed_at) from voucher_log ;</code></p>
  
  <p>But, I am getting the below error on executing this:</p>
  
  <blockquote>
    <p>ERROR 1241 (21000): Operand should contain 1 column(s)</p>
  </blockquote>