mysql数值计算函数_MySQL数值运算符和函数

对于普通加减法运算，此处不予详细讲解，如下例：mysql> SELECT 3+4;

+-----+

| 3+4 |

+-----+

| 7 |

+-----+

1 row in set (0.03 sec)

CEIL和FLOOR

CEIL为向上取整，只要有小数位，不管是几，直接入一位。例如：mysql> SELECT CEIL(3.01);

+------------+

| CEIL(3.01) |

+------------+

| 4 |

+------------+

1 row in set (0.02 sec)

FLOOR与此

相反mysql> SELECT FLOOR(3.99);

+-------------+

| FLOOR(3.99) |

+-------------+

| 3 |

+-------------+

1 row in set (0.00 sec)

p和MOD

p为取整，MOD为取余mysql> SELECT 3/4;

+--------+

| 3/4 |

+--------+

| 0.7500 |

+--------+

1 row in set (0.00 sec)

mysql> SELECT 3 p 4;

+---------+

| 3 p 4 |

+---------+

| 0 |

+---------+

1 row in set (0.00 sec)

mysql> SELECT 3 MOD 4;

+---------+

| 3 MOD 4 |

+---------+

| 3 |

+---------+

1 row in set (0.00 sec)

注：MOD可以换成％

POWER幂运算

例如3的2次方mysql> SELECT POWER(3,2);

+------------+

| POWER(3,2) |

+------------+

| 9 |

+------------+

1 row in set (0.14 sec)

ROUND四舍五入

例如3.652保留小数点后两位。mysql> SELECT ROUND(3.652,2);

+----------------+

| ROUND(3.652,2) |

+----------------+

| 3.65 |

+----------------+

1 row in set (0.00 sec)

保留小数点后一位：mysql> SELECT ROUND(3.652,1);

+----------------+

| ROUND(3.652,1) |

+----------------+

| 3.7 |

+----------------+

1 row in set (0.00 sec)

TRUNCATE

直接去掉某几位mysql> SELECT TRUNCATE(125.89,2);

+--------------------+

| TRUNCATE(125.89,2) |

+--------------------+

| 125.89 |

+--------------------+

1 row in set (0.00 sec)

mysql> SELECT TRUNCATE(125.89,1);

+--------------------+

| TRUNCATE(125.89,1) |

+--------------------+

| 125.8 |

+--------------------+

1 row in set (0.00 sec)

mysql> SELECT TRUNCATE(125.89,0);

+--------------------+

| TRUNCATE(125.89,0) |

+--------------------+

| 125 |

+--------------------+

1 row in set (0.00 sec)

mysql> SELECT TRUNCATE(125.89,-1);

+---------------------+

| TRUNCATE(125.89,-1) |

+---------------------+

| 120 |

+---------------------+

1 row in set (0.00 sec)

以上就是MySQL数值运算符和函数的内容，更多相关内容请关注PHP中文网(www.gxlcms.com)！

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网