mysql 当两个字段想减时，如果其中一个或两个字段的类型的unsigned无签名类型，如果想减的值小于0则会报错（BIGINT UNSIGNED value is out of range）
测试：
select cast(1 as unsigned)-2
select 0-cast(1 as unsigned)
解决办法：
一、修改字段类型
二、使用cast函数转字段为signed类型
select cast(1 as signed)-2
相关文章
- Mysql ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in..的解决方法
- BIGINT UNSIGNED value is out of range in..的解决方法
- Mysql ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in..的解决方法
- Mysql ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in..的解决方法
- 处理unsigned相减错误（BIGINT UNSIGNED value is out of range）
- MySQL BIGINT UNSIGNED value is out of range... 的问题和解决
- destoon-后台处理申请退款提交后出现“MySQL Error:BIGINT UNSIGNED value is out of range in '(`s
- destoon-后台处理申请退款提交后出现“MySQL Error:BIGINT UNSIGNED value is out of range in '(`s
- MySQL BIGINT UNSIGNED value is out of range... 的问题和解决
- [Err] 1690 - BIGINT UNSIGNED value is out of range in