1.取整
1.ceil () /ceiling() 向上取整
ex: ceil(1.2) = 2
2.floor () 向下取整
ex: floor(1.2) = 1
3.round() 四舍五入
2.获取UUID
select uuid();
-- 去掉'-'
select replace(uuid(), '-', '');
1.ceil () /ceiling() 向上取整
ex: ceil(1.2) = 2
2.floor () 向下取整
ex: floor(1.2) = 1
3.round() 四舍五入
select uuid();
-- 去掉'-'
select replace(uuid(), '-', '');