title: Mysql how to add value to a current value
body: <p>i am working on some Mysql assignment and was asked to:</p>
  
  <p>All the employees who are managers (leaders, type 'L') get a salary increase of 6%.</p>
  
  <p>i tried to use this method:</p>
  
  <pre><code>UPDATE employee
  SET salary = salary * '1,06'
  WHERE emptype = 'L';
  </code></pre>
  
  <p>and i get an Error message Error Code: 1292. truncated incorrect DOUBLE value: '1,06'</p>
  
  <p>When i try to DESCRIBE employee;</p>
  
  <p>i can see the salary to be Type int(11)</p>
  
  <p>Can someone tell what i have done wrong and how the correct codding is, and is it possible to add those 6% on the current value without changing the Type?</p>