Numeric value out of range: 1264 in mysql

Question

My mistake,

SQLSTATE [22003] numerical value outside the range: 1264 value is out of range for the column "pro_price_dis" in row 1 (SQL: insert into rp_cal_table ( productID , RSP_dis , RSP_mar , RRP_mar cont_RRP_mar , cont_RSP_mar , sea_cloud_price , sea_cloud_sal_price , pro_price_dis , mar_pro_price_dis , pro_price_mar , mar_pro_price_mar , sal_pro_price , mar_sal_pro_price , method , DB_price , updated_at , created_at ) values ​​(32, 0, 0, 0.4, 630.4, 0, 0.30, 0, 1103.2, 0.14285714285714, 1153.1707317073, 0.18, 0, 0, 1153.170770 04-12 10:38: 56, 2017-04-12 10:38:56))

my data type is decimal(8,5) , but still I get this error.

how can Ignore and insert, if it is larger also after. (Dot).

Answer 1

Column value

 1103.2 

but you indicate that the data type is decimal(8,5) , which means that the maximum allowed number is

 999.99999 

since 8 is the total limit minus decimal places