title: Numeric value out of range: 1264 in mysql
body: <p>My Error,</p>
  
  <blockquote>
    <p>SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pro_price_dis' at row 1 (SQL: insert into <code>rp_cal_table</code> (<code>productID</code>, <code>RSP_dis</code>, <code>RSP_mar</code>, <code>RRP_mar</code>, <code>cont_RRP_mar</code>, <code>cont_RSP_mar</code>, <code>sea_cloud_price</code>, <code>sea_cloud_sal_price</code>, <code>pro_price_dis</code>, <code>mar_pro_price_dis</code>, <code>pro_price_mar</code>, <code>mar_pro_price_mar</code>, <code>sal_pro_price</code>, <code>mar_sal_pro_price</code>, <code>method</code>, <code>DB_price</code>, <code>updated_at</code>, <code>created_at</code>) values (32, 0, 0, 0.4, 630.4, 0, 0.30, 0, 1103.2, 0.14285714285714, 1153.1707317073, 0.18, 0, 0, , 1153.1707317073, 2017-04-12 10:38:56, 2017-04-12 10:38:56))</p>
  </blockquote>
  
  <p>my datatype is <code>decimal(8,5)</code>  but still i am getting this error. </p>
  
  <p>how can i igone and insert if it is more also after .(Dot).</p>