mysql数据库:
1.向上/向下取整:
向上取整:
select CEILING(1.23);
执行结果
2
向下取整:
select FLOOR(1.23);
执行结果
1
2.字符串截取:
select substring_index('Hello World!',' ',1)
执行结果
Hello
select substring_index('Hello World!',' ',-1)
执行结果
World!
3.序号排序:
SELECT (@a:=@a+1) b FROM `xxxtable(表名)`, (SELECT @a:=0) as c;
4.非四舍五入保留小数点第n位:
SELECT TRUNCATE(123.4567, 3);
SELECT TRUNCATE(123.4567, 2);
SELECT TRUNCATE(123.4567, 1);
SELECT TRUNCATE(123.4567, 0);
SELECT TRUNCATE(123.4567, -1);
SELECT TRUNCATE(123.4567, -2);
SELECT TRUNCATE(123.4567, -3);
5.四舍五入保留小数点第n位:
SELECT ROUND(123.4567, 3);
SELECT ROUND(123.4567, 2);
SELECT ROUND(123.4567, 1);
SELECT ROUND(123.4567, 0);
SELECT ROUND(123.4567, -1);
SELECT ROUND(123.4567, -2);
SELECT ROUND(123.4567, -3);
后续实际开发中遇见了补充(欢迎网友留言补充)~: