MySQL Mathematical Functions

MySQL 수학함수 정도 ???

 

Name	Description
ABS()	Return the absolute value
ACOS()	Return arc cosine
ASIN()	Return arc sine
ATAN()	Return arc tangent
ATAN2(), ATAN()	Return the arc tangent of the two argument
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
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
LOG()	Return the natural logarithm of the first argument
LOG10()	Return the base-10 logarithm of the argument
LOG2()	Return the base-2 logarithm of the argument
MOD()	Return the remainder()
PI()	Return the value of pi
POW()	Return the argument raised to the specified power
POWER()	Return the argument raised to the specified power
RADIANS()	Return argument converted to the specified power
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
TRUNCATE()	Truncate the specified number of decimal places

* All mathematical functions return NULL in the event of an error

 

 

첨 보는 것도 많고, 익숙한 것도 있고, 어설프게 한번쯤 써 본 것도 있지만, 굵게 칠해놓은 9개 정도만 다시 한번 살펴볼까 한다.