整数型

– 创建整形表格

create table my_int1(
int_1 tinyint,
int_2 smallint,
int_3 int,
int_4 bigint
)charset utf8;

---

插入数据

insert into my_int1 values(100,100,100,100);
insert into my_int1 values(99,88,77,66);
alter table my_int1 add int_5 tinyint unsigned; (无符号类型 int_5)

insert into my_int1 values(11,1000,10000,1234,255);