MySQL 숫자 함수 및 연산자

MySQL Numeric Functions and Operators

MySQL 숫자 함수 및 연산자

1 목록

함수	설명
ABS()	★ Return the absolute value
ACOS()	Return the arc cosine
ASIN()	Return the arc sine
ATAN2(), ATAN()	Return the arc tangent of the two arguments
ATAN()	Return the arc tangent
CEIL()	Return the smallest integer value not less than the argument
CEILING()	Return the smallest integer value not less than the argument
CONV()	Convert numbers between different number bases
COS()	★ Return the cosine
COT()	Return the cotangent
CRC32()	Compute a cyclic redundancy check value
[[DEGREES()	Convert radians to degrees
[[DIV	Integer division
[[/	Division operator
[[EXP()	★ Raise to the power of
[[FLOOR()	Return the largest integer value not greater than the argument
[[LN()	Return the natural logarithm of the argument
[[LOG10()	Return the base-10 logarithm of the argument
[[LOG2()	Return the base-2 logarithm of the argument
[[LOG()	Return the natural logarithm of the first argument
[[-	Minus operator
[[MOD()	Return the remainder
% or MOD	Modulo operator
PI()	★ Return the value of pi
+	Addition operator
POW()	Return the argument raised to the specified power
POWER()	Return the argument raised to the specified power
RADIANS()	Return argument converted to radians
RAND()	Return a random floating-point value
ROUND()	Round the argument
SIGN()	Return the sign of the argument
SIN()	★ Return the sine of the argument
SQRT()	★ Return the square root of the argument
TAN()	★ Return the tangent of the argument
*	Multiplication operator
TRUNCATE()	Truncate to specified number of decimal places
-	Change the sign of the argument

2 같이 보기

• MySQL 매뉴얼