bigint.test
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 0k
Category:

MySQL

Development Platform:

Visual C++

  1. #
  2. # Test of reading of bigint values
  3. #
  4. select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296;
  5. select 9223372036854775807,-009223372036854775808;
  6. select +9999999999999999999,-9999999999999999999;
  7. drop table if exists t1;
  8. create table t1 (a bigint unsigned);
  9. insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFF);
  10. select * from t1;
  11. drop table t1;