数字

进入交互模式。

sqlite3

为了方便换行，交互模式不能省略结尾分号，SQL 文件则可以通过空行省略结尾分号。

显示标题。

.header on

加法。

SELECT 1 + 2 AS result;

result
3

SELECT 0.1 + 0.2 AS result;

result
0.3

减法。

SELECT 7 - 2 AS result;

result
5

SELECT 0.7 - 0.2 AS result;

result
0.5

乘法。

SELECT 3 * 4 AS result;

result
12

SELECT 0.3 * 0.4 AS result;

result
0.12

除法。

SELECT CAST(8 AS REAL) / 2 AS result;

result
4.0

SELECT CAST(7 AS REAL) / 2 AS result;

result
3.5

SELECT 0.8 / 0.2 AS result;

result
4.0

取整。

SELECT 8 / 2 AS result;

result
4

SELECT 7 / 2 AS result;

result
3

SELECT CAST(2.5 AS INTEGER) AS result;

result
2

舍入。

SELECT ROUND(2.5) AS result;

result
3.0

为了兼容性，向上取整支持 ceil ceiling 。

SELECT CEIL(3.5) AS result;

result
4.0

SELECT CEILING(3.5) AS result;

result
4.0

向下取整。

SELECT FLOOR(3.5) AS result;

result
3.0

取余。

SELECT 8 % 2 AS result;

result
0

SELECT 7 % 2 AS result;

result
1