hi,all
Пожалуйста, объясните мне глупому:
mysql> create table test(some bigint unsigned);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values(-1);
Query OK, 1 row affected (0.00 sec)
mysql> select some+1 from test;
+--------+
| some+1 |
+--------+
| 0 |
+--------+
1 row in set (0.00 sec)
mysql> select sum(some)+1 from test;
+----------------------+
| sum(some)+1 |
+----------------------+
| 18446744073709551616 |
+----------------------+
1 row in set (0.00 sec)
mysql>
--
--------
Regards,
Pavel.
"He's the kind of man for the times that need the kind of man he is ..."
===================================================================
uanog mailing list.
To Unsubscribe: send mail to majordomo(a)uanog.kiev.ua
with "unsubscribe uanog" in the body of the message
