Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at ro
来源:互联网 发布:在线考试管理系统php 编辑:程序博客网 时间:2024/05/22 23:57
在mysql插入数据的时候出现这种错误:Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
; SQL []; Data truncation: Data too long for column 'content' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at row 1
解决:字段长度不够,即使设置为了text还是不够,因为text类型是可变长度的字符串,最多65535个字符,所有,最好是把字段类型设置为longtext,最多存放4294967295个字符
步骤:进入mysql,use你要改变的数据库,执行语句:alter table t_blog modify column content longtext;
重启mysql,linux下语句:service mysqld restart
阅读全文
0 0
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at ro
- ### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column \'name\' at row 1
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' a
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Eexception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PIC' at
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at r
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column MenuGrpCode at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'sex' at row 1”
- 数据库编码com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'sex' at row 1
- ssh框架中的错误:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'user_name'
- Mysql MysqlDataTruncation Data truncation Data too long for column
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorr
- MySql的Blob字段报错:Data truncation: Data too long for column 'CONTENT' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'price'
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'rdate'
- 杭电acm2039:给三边长判断能不能构成三角形
- 优先级高的线程并不一定先执行
- Win10切换到了Users用户怎么切换回来
- SMTP connect() failed 解决方案
- 图片上传预览
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'content' at ro
- 虚拟机安装
- Spark wordcount开发并提交到单机(伪分布式)运行
- 谈谈我对JavaScript中闭包的理解
- Qt 学习之路 2(5):自定义信号槽
- 【Link】Building for MacOSX, but linking against dylib built for iOS Simulator file
- linux下azkaban安装及示例
- openjudge 4147 汉诺塔问题(Hanoi)
- leetcode 之 Longest Common Prefix