title: MYSQL Insert results of concat
body: <p>I have a table with 4 columns:</p>
  
  <pre><code>ID     ORDER_ID     QTY     VALUE     
  1       153          1        0
  2       476          1        0
  3       453          9        1
  4       719          2        2 
  </code></pre>
  
  <p>With this table, I have to concat " " to the values of QTY and VALUE and then store it back in the table, so it can look like this (Both, <code>qty</code> and <code>value</code> are TEXT):</p>
  
  <pre><code>ID     ORDER_ID     QTY     VALUE     
  1       153         "1"      "0"
  2       476         "1"      "0"
  3       453         "9"      "1"
  4       719         "2"      "2" 
  </code></pre>
  
  <p>To concat the values, I use the following:</p>
  
  <pre><code>SELECT CONCAT('"',qty,'"') qty, 
  CONCAT('"',`VALUE`,'"') VALUE
  FROM `myTable`;
  </code></pre>
  
  <p>Now, when I try to use:</p>
  
  <pre><code>INSERT INTO `myTable` (`order_id`, `qty`, `value`) 
  SELECT `order_id`, CONCAT('"',qty,'"') , CONCAT('"',value,'"')  
  FROM `1.1`;
  </code></pre>
  
  <p>This basically blanks my entire table.</p>
  
  <p>However, if I use a single concat, I can get the desired output stored but the rest of the fields are blank.</p>
  
  <pre><code> INSERT INTO `myTable` (`qty`) 
      SELECT CONCAT('"',qty,'"')
   FROM `1.1`;
  </code></pre>
  
  <p>Sorry if this is a newb question but I did try to search no to avail.</p>
  
  <p>Thank You.</p>