create table if not exists t_flttst (recid int unsigned
 not null primary key, numflt float);
delete from t_flttst;
insert into t_flttst (recid, numflt) values (0,1234500);
insert into t_flttst (recid, numflt) values (1,123450);
insert into t_flttst (recid, numflt) values (2,12345);
insert into t_flttst (recid, numflt) values (3,1234.50);
insert into t_flttst (recid, numflt) values (4,123.450);
insert into t_flttst (recid, numflt) values (5,12.3450);
insert into t_flttst (recid, numflt) values (6,1.23450);
insert into t_flttst (recid, numflt) values (7,0.123450);
insert into t_flttst (recid, numflt) values (8,0.0123450);
insert into t_flttst (recid, numflt) values (9,0.00123450);
insert into t_flttst (recid, numflt) values (10,0.00123450);
insert into t_flttst (recid, numflt) values (11,1.260);
insert into t_flttst (recid, numflt) values (12,1.250);
insert into t_flttst (recid, numflt) values (13,1.240);
insert into t_flttst (recid, numflt) values (14,1.230);
insert into t_flttst (recid, numflt) values (15,12.250);
insert into t_flttst (recid, numflt) values (17,0.250);
select * from t_flttst order by recid;
select * from t_flttst where numflt = 1234500 \p;
select * from t_flttst where numflt = 123450 \p;
select * from t_flttst where numflt = 12345 \p;
select * from t_flttst where numflt = 1234.5 \p;
select * from t_flttst where numflt = 123.45 \p;
select * from t_flttst where numflt = 12.345 \p;
select * from t_flttst where numflt = 1.2345 \p;
select * from t_flttst where numflt = 0.12345 \p;
select * from t_flttst where numflt = 1.26 \p;
select * from t_flttst where numflt = 1.25 \p;
select * from t_flttst where numflt = 1.24 \p;
select * from t_flttst where numflt = 1.23 \p;
select * from t_flttst where numflt = 1.25 \p;
select * from t_flttst where numflt = 0.25 \p;
