mysql数据类型区别

create table t1(c1 float(10,2), c3 decimal(10,2));

insert into t1 values(1234567.23, 1234567.23,1234567.23);

insert into t1 values(9876543.21, 9876543.12,9876543.21);

insert into t1 values(1.21, 1.12,1.21);

insert into t1 values(1.216, 1.126,1.216);

insert into t1 values(-98765430.21, -98765430.12, -98765430.12);

 

select * from t1;