MySQL——数学函数

# 数学函数
SELECT ABS(-10) FROM DUAL; -- abs绝对值

SELECT BIN(10) FROM DUAL; -- 十进制转二进制，输出1010

SELECT CEILING(1.1) FROM DUAL; -- 向上取整，返回比1.1大的最小整数

SELECT CONV(8, 10, 2) FROM DUAL; -- 8是十进制，转为二进制

SELECT FLOOR(1.1) FROM DUAL; -- 向下取整，返回比1.1小的最大整数

SELECT FORMAT(78.123456,2) FROM DUAL; -- 保留两位小数

SELECT LEAST(0,1,-10) FROM DUAL; -- 返回最小值

SELECT MOD(8,16) FROM DUAL; -- 求余

SELECT RAND() FROM DUAL;   -- 随机数，0 <= num <= 1
SELECT RAND(1) FROM DUAL;   -- 随机数，0 <= num <= 1,RNAD(seed),seed不变则随机数不变