java - 收到 sql 错误 1265 且不确定原因

Question

尝试从 java 应用程序插入时出现 1265 错误，但尝试从 phpmyadmin 插入时工作正常？
知道为什么吗？
或者我如何判断哪个字段出现错误
我正在运行一个 java 应用程序，将数据输入到 mysql 数据库 插入是在错误发生之前运行的查询 我查找了这个错误 1265，它似乎是在尝试输入更大的值然后在表中分配时发生的
但是当我从 phpmyadmin 运行插入的这个字符串时，它接受它

  insert into delivery (`truckid`, `Factory`, `rangedelivery`, `deliverydate`, `deliveryid`, 
        `costdocument`, `amount`, `completion`, `sumamount`, `pricelist`, `delivery`, 
        `standbytime`, `waiting`, `night`, `descriptionextra`, `extension`, `mixing`, `value`) 
        VALUES ('460', 'N041', '0037', '2016-05-24', '6400439688', '5674250',
        '14.00', '0.00', '14.00', '81.57', '1,141.98', '0.00', '0.00', '0.00', '', '0.00', '114.20', '1256.18')
        SQLException: Data truncated for column 'delivery' at row 1
        SQLState: 01000
        VendorError: 1265

Answer 1

尝试删除逗号“1,141.98”

 insert into delivery (`truckid`, `Factory`, `rangedelivery`, `deliverydate`, `deliveryid`, 
    `costdocument`, `amount`, `completion`, `sumamount`, `pricelist`, `delivery`, 
    `standbytime`, `waiting`, `night`, `descriptionextra`, `extension`, `mixing`, `value`) 
    VALUES ('460', 'N041', '0037', '2016-05-24', '6400439688', '5674250',
    '14.00', '0.00', '14.00', '81.57', '1141.98', '0.00', '0.00', '0.00', '', '0.00', '114.20', '1256.18')