----mysql5.7---
括号里的数字叫数据的宽度,不同的数据类型对宽度的处理也不一样。
1、整数类型
create table test2 (
id1 bigint(10) zerofill,
id11 bigint(10) ,
id2 bigint zerofill,
id22 bigint ,
id3 bigint(1) zerofill,
id33 bigint(1)
);
insert into test2 values(1,1,2,2,30,30);
select * from test2;
---------------------------------
# id1, id11, id2, id22, id3, id33
0000000001, 1, 00000000000000000002, 2, 30, 30
show create table test2;
---------------------------------
# Table Create Table
test2 CREATE TABLE `test2` (
`id1` bigint(10) unsigned zerofill DEFAULT NULL,
`id11` bigint(10) DEFAULT NULL,
`id2` bigint(20) unsigned zerofill DEFAULT NULL,
`id22` bigint(20) DEFAULT NULL,
`id3` bigint(1) unsigned zerofill DEFAULT NULL,
`id33` bigint(1) DEFAULT NULL