关于MySQL的整型数据的内存溢出问题的应对方法

SELECTCAST(0ASUNSIGNED)-1;
 
SELECT9223372036854775807+1;

mysql>SELECTCAST(0ASUNSIGNED)-1;
+-------------------------+|CAST(0ASUNSIGNED)-1|+-------------------------+|18446744073709551615|+-------------------------+1ROWINSET(0.01 sec)
 
mysql>SELECT9223372036854775807+1;
+-------------------------+|9223372036854775807+1|+-------------------------+|-9223372036854775808|+-------------------------+1ROWINSET(0.01 sec)

mysql>SELECTCAST(0ASUNSIGNED)-1;
ERROR 1690(22003): BIGINTUNSIGNEDVALUEISOUTOF range IN'(cast(0 as unsigned) - 1)'
mysql> 
mysql> 
mysql> 
mysql>SELECT9223372036854775807+1;
ERROR 1690(22003): BIGINTVALUEISOUTOF range IN'(9223372036854775807 + 1)'