Mysql 更新字段类型异常处理:ERROR 1265 (01000): Data truncated for column 'xxx' at row 1
来源:互联网 发布:怎样制作淘宝店招 编辑:程序博客网 时间:2024/06/04 20:05
Mysql 更新字段类型异常处理:ERROR 1265 (01000): Data truncated for column ‘xxx’ at row 1
MySQL中需要修改表字段的默认值,在研发环境测试执行SQL没有问题:
mysql> alter table `user` MODIFY COLUMN `weight` int(11) NOT NULL DEFAULT 0 COMMENT '权重分'; Query OK, 330271 rows affected (2.76 sec)Records: 330271 Duplicates: 0 Warnings: 0
原来的字段类型是这样的:
结果在生产环境执行异常:
mysql> alter table `user` MODIFY COLUMN `weight` int(11) NOT NULL DEFAULT 0 COMMENT '权重分';ERROR 1265 (01000): Data truncated for column 'weight' at row 1
网上查询说有可能是字段类型的问题,仔细核对字段类型,发现没有问题。
换种思路,将字段中的值先更新为0,然后再更新,成功了。可能是MySQL版本不同,导致执行结果有区别。
mysql> update `user` set `weight` = 0 where `weight` is null;Query OK, 330271 rows affected (5.80 sec)Rows matched: 330271 Changed: 330271 Warnings: 0mysql> alter table `user` MODIFY COLUMN `weight` int(11) NOT NULL DEFAULT '0' COMMENT '权重分';Query OK, 330271 rows affected (2.76 sec)Records: 330271 Duplicates: 0 Warnings: 0
再通过desc查看表结构,搞定!:
0 0
- Mysql 更新字段类型异常处理:ERROR 1265 (01000): Data truncated for column 'xxx' at row 1
- mysql导入文件出现Data truncated for column 'xxx' at row 1的原因
- Warning(1265)Data truncated for column 'v_mmi' at row 1
- mysql报错:1265 - Data truncated for column 'heroType' at row 1
- Data truncation: Data truncated for column 'content' at row 1
- Data truncation: Data truncated for column 'xxxxxxxxx' at row 1
- Data truncated for column at row
- load data 报错" truncated for column..... at row 1"
- Data truncated for column 'id' at row 1
- Warning: Data truncated for column at row 1
- BatchUpdateException: Data truncated for column 'id' at row 1
- MYSQL写入中文错误 —— Data too long for column 'xxx' at row 1
- MySql 弹出“data too long for column 'xxx' at row 1"解决方法
- java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
- java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
- java.sql.BatchUpdateException: Data truncated for column 'nowCost' at row 1
- java.sql.SQLException: Data truncated for column 'uid' at row 1
- 【报错】BatchUpdateException: Data truncated for column 'id' at row 1
- wait使用
- 数据库类别
- 获取各种随机数的代码工具类
- 浅谈文件上传的几种技术
- linux端口详解大全
- Mysql 更新字段类型异常处理:ERROR 1265 (01000): Data truncated for column 'xxx' at row 1
- mysql学习之主从复制
- Rxjava操作符
- Spring4.3.x 浅析xml配置的解析过程(4)——解析bean标签及其所有子标签
- 改变myeclipse中Java项目的名称,在浏览器中使用新名称访问项目时报404的问题的解决方法!!!
- ideaUI找不到maven依赖包的解决
- Flatten Binary Tree to Linked List
- openvswitch--OpenFlow 流表设置
- nextInt()方法注意换行符