1 echo float data
type testing
;
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 echo select * from t1
;
12 ---------------------------------------------------------
14 ---------------------------------------------------------
21 123456.000000 10.234000
24 echo select * from t1 where f1 BETWEEN
0.104856 AND
0.104858
25 select * from t1 where f1 BETWEEN
0.104856 AND
0.104858;
26 echo select * from t1 where f1
>122 AND f1
<124;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
32 echo select * from t1 where f1 BETWEEN
-0.104859 AND
-0.104856
33 select * from t1 where f1 BETWEEN
-0.104859 AND
-0.104856
;
34 echo select * from t1 where f1 BETWEEN
-124 AND
-122
35 select * from t1 where f1 BETWEEN
-124 AND
-122;
36 echo select * from t1 where f2
< f1
;
37 ---------------------------------------------------------
39 ---------------------------------------------------------
44 123456.000000 10.234000
47 echo update t1
set f2
= 3.4345 where f2
>11;
48 Statement Executed
: Rows Affected
= 4
49 ---------------------------------------------------------
51 ---------------------------------------------------------
58 123456.000000 10.234000
61 echo delete from t1 where f1
> 14.234;
62 Statement Executed
: Rows Affected
= 4
63 ---------------------------------------------------------
65 ---------------------------------------------------------