测试方案如下:
sqlite> select 100%3;
+-------+
| 100%3 |
+-------+
| 1 |
+-------+
1 row in set
sqlite> select 100/3;
+-------+
| 100/3 |
+-------+
| 33 |
+-------+
1 row in set
sqlite> select 100.0/3;
+------------------+
| 100.0/3 |
+------------------+
| 33.3333333333333 |
+------------------+
1 row in set
sqlite> select FLOOR(100.0)/3; 说明FLOOR函数返回的是"整数"。
+----------------+
| FLOOR(100.0)/3 |
+----------------+
| 33 |
+----------------+
1 row in set
sqlite> select 100/3.0;
+------------------+
| 100/3.0 |
+------------------+
| 33.3333333333333 |
+------------------+
1 row in set
sqlite> select 100/POWER(3,1); 说明POWER函数返回的是"浮点数"。
+------------------+
| 100/POWER(3,1) |
+------------------+
| 33.3333333333333 |
+------------------+
1 row in set
sqlite> select TYPEOF(POWER(3,1)); 用typeof函数可以查看数据的类型。
+--------------------+
| TYPEOF(POWER(3,1)) |
+--------------------+
| real |
+--------------------+
1 row in set
sqlite>
完。