mysql数据类型--bigint(M)\varchar(M)\datetime(M)\decimal(M,D)

----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