create table my_int
(
int _1 tinyint,
int _2 smallint,
int _3 int,
int _4 bigint
)charset utf8;
插入数据
inset into my_int values(100,100,100,100);
给表增加无符号类型
alter table my_int add int_5 tinyint unsigned; 无符号
插入数据
insert into my_int valies(127,1000,1000,10000,255);
alter table my_int add int_6 tinyint (1) unsigned; 指定宽度为1
alter table my_int add int _7 tinyint(2) zerofill ; 显示宽度为2 0填充