int范围：
-2,147,483,648 ~ 2,147,483,647
int unsinged范围:
0 ~ 4,294,967,295
十六机制：oxffffffff
CREATE TABLE t1 (a INT UNSIGNED,b INT UNSIGNED) ENGINE =INNODB;
INSERT INTO t1 SELECT 1,2;
SELECT * FROM t1;
14:40>SELECT a - b FROM t1;
+----------------------+
| a - b |
+----------------------+
| 18446744073709551615 |
+----------------------+
1 row in set (0.00 sec)
查询到的改值已经超过int unsigned的范围。求解？
阅读(1337) | 评论(0) | 转发(0) |
