mysql:decimal列类型相减超出范围
库名:test
表名:goods
列属性
mysql语句:
select goods_id,goods_name,(market_price-shop_price) as discount from goods where cat_id!=3;
错误:
ERROR 1690 (22003): DECIMAL UNSIGNED value is out of range in '(`test`....
原创
2019-11-13 19:49:10 ·
2307 阅读 ·
0 评论