数值超出范围:在MySQL中为1264 [英] Numeric value out of range: 1264 in mysql

问题描述

我的错误，

SQLSTATE [22003]:数值超出范围:1264行1的列'pro_price_dis'的超出范围值(SQL:插入rp_cal_table(productID，RSP_dis，RSP_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)值(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))

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'pro_price_dis' at 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.1707317073, 2017-04-12 10:38:56, 2017-04-12 10:38:56))

我的数据类型是decimal(8,5)，但仍然出现此错误.

my datatype is decimal(8,5) but still i am getting this error.

如果在(.Dot)之后也插入和插入行话，该怎么办?

how can i igone and insert if it is more also after .(Dot).

推荐答案

该列的值为

1103.2

但是您提到的数据类型为decimal(8,5)，这意味着允许的最大数量为

but you mention the data type is decimal(8,5) which means the max number allowed is

999.99999

因为8是总精度减去小数位

这篇关于数值超出范围:在MySQL中为1264的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！