MySql 插入时报：Data truncation: Data too long for column ‘xxx‘ at row 1

最新推荐文章于 2025-02-14 14:01:14 发布

大叔0769

最新推荐文章于 2025-02-14 14:01:14 发布

阅读量1.4k

点赞数

分类专栏： MYSQL 文章标签： mybatis mysql java

本文链接：https://blog.youkuaiyun.com/weixin_51587574/article/details/127889896

版权

MYSQL 专栏收录该内容

1 篇文章

订阅专栏

测试插入数据时，报错，查看日志如下：

Data truncation: Data too long for column 'xxx' at row 1

Caused by: org.springframework.dao.DataIntegrityViolationException: 
### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'text' at row 1 
### The error occurred while setting parameters 
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'text' at row 1 
; Data truncation: Data too long for column 'text' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'text' at row 1 
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104) 
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) 
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) 
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) 
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) 
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) 
	at com.sun.proxy.$Proxy96.insert(Unknown Source)

提示说插入内容过长，那就是数据库字段设计太短了。

解决方案：