今天插入mysql数据数据时，报错Data truncated for column。研究了一下原理是我数据的长途超出了该字段的最大长度，所以解决办法很简单，就是修改数据库中字段属性，使其长度增加即可~
相关文章
- mysql Out of range value adjusted for column导致Warning(1265)Data truncated for column 'column_name' at row 1
- Mysql 错误1366, "Incorrect string value: '\\xE6\\xB7\\xB1\\xE5\\x85\\xA5...' for column '
- 1366 - Incorrect string value:'\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' a 错误修改
- MySQL中文字符解决方案[Data too long for column XX at row n]
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'date' at row 1
- SSM-物流管理常见问题1Data truncation: Incorrect datetime value: '' for column 'posttime' at row 1
- Data truncation: Incorrect datetime value: '' for column 'start' at row 1的解决方法
- Oracle数据泵(Data Dump)错误汇集
- MySql系列：中文写入数据库出现错误java.sql.SQLException: Incorrect string value: '\xE5\xxxx' for column 'xxxx' at r
- 【转】Mysql 插入中文错误：Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1