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;

mysql数据类型区别

原文：http://www.cnblogs.com/andydao/p/5292976.html