[MySQL] SQL 내장함수 : 숫자함수

SQL 숫자함수

 

산술연산 (+ - * / ) 

mysql> select 3+9;
+-----+
| 3+9 |
+-----+
|  12 |
+-----+
1 row in set (0.00 sec)

 

Mod(값1, 값2) : 값1을 값2로 나눈 나머지

mysql> select mod(10,3);
+-----------+
| mod(10,3) |
+-----------+
|         1 |
+-----------+
1 row in set (0.00 sec)

 

Round(값, 자리수) : 소수점 자르기

• round(값, -1) : 올림

mysql> select round(123.5,0);
+----------------+
| round(123.5,0) |
+----------------+
|            124 |
+----------------+
1 row in set (0.00 sec)

mysql> select round(123456,-1);
+------------------+
| round(123456,-1) |
+------------------+
|           123460 |
+------------------+
1 row in set (0.00 sec)

 

Celling : 올림 / floor : 버림

sqrt : 루트 / fow : 제곱

 

Rand() : 0~1사이의 아무 숫자

mysql> select rand();
+--------------------+
| rand()             |
+--------------------+
| 0.9747020387786459 |
+--------------------+
1 row in set (0.00 sec)

mysql> select floor(rand()*10);
+------------------+
| floor(rand()*10) |
+------------------+
|                9 |
+------------------+
1 row in set (0.00 sec)