title: insert data from one table to another in mysql
body: <p>i want to read all data from one table and insert some data in to another table. my query is </p>
  
  <pre><code>  INSERT INTO mt_magazine_subscription ( 
        magazine_subscription_id, 
        subscription_name, 
        magazine_id, 
        status ) 
    VALUES ( 
        (SELECT magazine_subscription_id, 
                subscription_name, 
                magazine_id 
         FROM tbl_magazine_subscription 
         ORDER BY magazine_subscription_id ASC), '1')
  </code></pre>
  
  <p>but i got an error that </p>
  
  <pre><code>  #1136 - Column count doesn't match value count at row 1
  </code></pre>
  
  <p>please help me.</p>