Mysql字段属性之——bigint_mysql bigint字段-优快云博客

本文链接：https://blog.youkuaiyun.com/YFSREAD/article/details/122071883

本文详细介绍了MySQL中bigint数据类型的使用特点，包括不同属性如UNSIGNED和ZEROFILL的效果，以及它们如何影响数值的存储与展示。通过具体的表格定义与插入实例，帮助读者理解bigint类型在实际应用中的表现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE TABLE test6 (
id bigint NOT NULL AUTO_INCREMENT,
num1 bigint NULL DEFAULT NULL,
num2 bigint(3) NULL DEFAULT NULL,
num3 bigint(3) UNSIGNED ZEROFILL NULL DEFAULT NULL,
num4 bigint UNSIGNED ZEROFILL NULL DEFAULT NULL,
name varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
num5 bigint(32) UNSIGNED ZEROFILL NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of test6
-- ----------------------------
INSERT INTO test6 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, 0, 00000000000000000000, '00',0);
INSERT INTO test6 VALUES (1, 1, 1,1, 00000000000000000001, '11',1);
INSERT INTO test6 VALUES (2, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO test6 VALUES (3, 9223372036854775807, 1, 9223372036854775807, 9223372036854775807, 'aa',9223372036854775807);
INSERT INTO test6 VALUES (9223372036854775807, 9223372036854775807, 9223372036854775807, 18446744073709551615, 18446744073709551615, '你好',18446744073709551615);

id	num1	num2	num3	num4	name	num5
-9223372036854775808	-9223372036854775808	-9223372036854775808	000	00000000000000000000	00	00000000000000000000000000000000
1	1	1	001	00000000000000000001	11	00000000000000000000000000000001
2	null	null	null	null	null
3	9223372036854775807	1	09223372036854775807	09223372036854775807	aa	00000000000009223372036854775807
9223372036854775807	9223372036854775807	9223372036854775807	18446744073709551615	18446744073709551615	你好	00000000000018446744073709551615