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;