Data truncated for column 'date' at row 1

2025-06-28 06:47:54

1、Error updating database. Cause: java.sql.SQLException: Data truncated for column 'seedid' at row 1控制台出现这个错误SQL: INSERT INTO sellinfo( phone, storephone, seedid, seedname, price, number, totalprofit, totalmoney, date, details ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Data truncated for column 'date' at row 1

3、省略set、get方法对应mapper文件<insert id="insert">INSERT INTO sellinfo(phone,storephone,seedid,seedname,price,number,totalprofit,totalmoney,date,details

Data truncated for column 'date' at row 1

5、一开始以为是sql语句写错,反复检查好几遍都没有错误;后来检查数据库发现数据库类型为int类型,和实体类不匹配修改为varchar,问题解决

Data truncated for column 'date' at row 1
声明:本网站引用、摘录或转载内容仅供网站访问者交流或参考,不代表本站立场,如存在版权或非法内容,请联系站长删除,联系邮箱:site.kefu@qq.com。
猜你喜欢