Data truncation: Out of range value for column 'Quality' at row 1

Q:

 Data truncation: Out of range value for column 'Quality' at row 1

 com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'Quality' at row 1

 

A:

You column Quality DOUBLE(1,1) can take input only 1 |2 |3

Double( totalsize, decimal), size is the number of characters.
Since your field length is small, the input overflows.
Update your table to fix this.

posted @ 2017-07-14 11:45  Faron  阅读(2461)  评论(0编辑  收藏  举报