SELECT ABS(-9) AS 绝对值
SELECT CEILING(9.4) AS 向上取整
SELECT FLOOR(9.23) AS 向上取整
SELECT RAND() -- AS 随机数(0_1之间)
SELECT SIGN(0) AS 符号函数 -- 负数返回-1
MYSQL常用函数
最新推荐文章于 2024-10-01 17:33:05 发布
SELECT ABS(-9) AS 绝对值
SELECT CEILING(9.4) AS 向上取整
SELECT FLOOR(9.23) AS 向上取整
SELECT RAND() -- AS 随机数(0_1之间)
SELECT SIGN(0) AS 符号函数 -- 负数返回-1