mysql数据库-数学函数

后端 / 2021-08-23

ABS

绝对值

# 绝对值 二进制
select val, abs(val) as abs, bin(val) as bin
from math_test;

BIN

10进制——>二进制

# 绝对值 二进制
select val, abs(val) as abs, bin(val) as bin
from math_test;

CEILING

向上取整

# 取整
select val, ceiling(val) as up, floor(val) as down
from math_test;

CONV

进制转换

# 进制转换
select val, conv(val, 10, 16) as conv
from math_test;

FLOOR

向下取整

# 取整
select val, ceiling(val) as up, floor(val) as down

FORMAT

保留小数

# 保留小数
select val, format(val, 1) as format
from math_test;

HEX

转十六进制

# 十六进制
select val, hex(val)
from math_test;

LEAST

求最小值

# 最小值
select val, least(val,3) as least
from math_test;

MOD

求余数

# 求余数
select val,mod(val,2)as mod_2
from math_test;

RAND

随机数

# 随机数
select rand()
from dual;

image.png