title: How can i insert my data in MySQL table in one column only
body: <p>somethings bothering me today and its how to insert my data in my table in a specific column. I don't know how so if anyone can help me I'd really really appreciate it.</p>
  
  <p>my table(holidaytype) has the fields:</p>
  
  <pre><code>-----------------------
  |id  |type |multiplier|
  | 1  |  R  |          |
  | 2  |  S  |          |
  </code></pre>
  
  <p>The id and type values must not be changed but the multiplier value will be coming from an input. I don't know what query should I be doing to do this.</p>
  
  <p>I've tried :</p>
  
  <pre><code>INSERT INTO holidaytype(multiplier)
  SELECT multiplier  
  FROM holidaytype
  WHERE `type` = 'R'
  </code></pre>
  
  <p>the results says : 1 row(s) affected Records: 1  Duplicates: 0  Warnings: 0 0.109 sec</p>