title: Warning#1264:out of range error in mysql
body: <p>The following query:</p>
  
  <pre><code>INSERT INTO skill (`emp_number`, `skill_id`, `year_exp`, `comments`)
  VALUES ('4', '3', '23.45', '')
  </code></pre>
  
  <p>It is producing the error : </p>
  
  <pre><code>1 row inserted.
  Warning: #1264 Out of range value for column 'year_exp' at row 1
  year_exp column is of datatype decimal(2,2)
  </code></pre>
  
  <p>Please  help me to pint out the error.</p>