bigint unsigned 插入表数据大于9233372036854775807，显示为0？

[dandan02]

BIGINT：8字节 大整数，带符号：-9223372036854775808~9233372036854775807，
不带符号：0~18446744073709551615
为什么定义为bigint unsigned数据类型后，还是不能存储大于9233372036854775807的数据。

[ACMAIN_CHM]

如下测试，没有你说的问题，建议你也同样贴出你的代码如下，否则你只是说说是0，但具体是什么呢？
另外，建议贴出来的测试代码先自己试一下，错误的代码别人还要帮你排错。

mysql> CREATE TABLE `data2010_5_10` (
    ->  `id` bigint(20) default NULL,
    ->  `instance` varchar(100) default NULL,
    ->  `ttime` bigint(20) default NULL,
    ->  `vvalue` bigint(21) unsigned default NULL,
    ->  KEY `polleddata0_ndx` (`pollid`),
    ->  KEY `polleddata1_ndx` (`instance`),
    ->  KEY `polleddata2_ndx` (`ttime`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ERROR 1072 (42000): Key column 'pollid' doesn't exist in table

mysql> CREATE TABLE `data2010_5_10` (
    ->  `id` bigint(20) default NULL,
    ->  `instance` varchar(100) default NULL,
    ->  `ttime` bigint(20) default NULL,
    ->  `vvalue` bigint(21) unsigned default NULL,
    ->  KEY `polleddata1_ndx` (`instance`),
    ->  KEY `polleddata2_ndx` (`ttime`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    -> ;
Query OK, 0 rows affected (0.08 sec)

mysql> insert into data2010_5_10(id,instance,ttime,vvalue) values(3,'3.3.2',1273
481590, 9223372036854775809);
Query OK, 1 row affected (0.03 sec)

mysql> select * from data2010_5_10;
+------+----------+------------+---------------------+
| id   | instance | ttime      | vvalue              |
+------+----------+------------+---------------------+
|    3 | 3.3.2    | 1273481590 | 9223372036854775809 |
+------+----------+------------+---------------------+
1 row in set (0.00 sec)

mysql>

[dandan02]

是工具显示的问题。

[ACMAIN_CHM]

给出你的建表 create table 语句和 insert 语句，应该可以啊。

[ACMAIN_CHM]

建议你用如下语句测试一下。

mysql> create table tx ( id BIGINT unsigned);
Query OK, 0 rows affected (0.16 sec)

mysql> insert into tx values (18446744073709551615);
Query OK, 1 row affected (0.05 sec)

mysql> select * from tx;
+----------------------+
| id                   |
+----------------------+
| 18446744073709551615 |
+----------------------+
1 row in set (0.00 sec)

mysql>

[dandan02]

CREATE TABLE `data2010_5_10` (
`id` bigint(20) default NULL,
`instance` varchar(100) default NULL,
`ttime` bigint(20) default NULL,
`vvalue` bigint(21) unsigned default NULL,
KEY `polleddata0_ndx` (`pollid`),
KEY `polleddata1_ndx` (`instance`),
KEY `polleddata2_ndx` (`ttime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


insert into data2010_5_10(id,instance,ttime,vvalue) values(3,'3.3.2',1273481590, 9223372036854775809)

执行时提示成功，但是表格中的vvalue字段值显示为0。

[shine333]

看上面狼头的测试代码，你的

unsigned

在哪里