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.

原文地址:https://www.cnblogs.com/printN/p/7169390.html