This section provides an alphabetical listing of MySQL-supported functions, with examples and corresponding results.
number
)
Returns the arc cosine of number
ranging
from -1 to 1. The result ranges from 0 to and is expressed in
radians. For example:
SELECT ACOS( 0 )
-> 1.570796
text
)
Returns the ASCII code of the first character of
text
. For example:
SELECT ASCII('x')
-> 120
number
)
Returns the arc sine of number
ranging
from -1 to 1. The resulting value ranges from -/2 to /2 and is
expressed in radians. For example:
SELECT ASIN( 0 )
-> 0.000000
number
)
Returns the arctangent of any number
. The
resulting value ranges from -/2 to /2 and is expressed in radians.
For example:
SELECT ATAN( 3.1415 )
-> 1.262619
x,y
)
Returns the arctangent of the two variables
x
and y
.
ATAN2(
x
,y
)
is similar to
ATAN(
y
/x
),
with the exception that the signs of x
and
y
are used to determine the quadrant of
the result. For example:
ATAN2(3.1415, 1)
-> 1.262619
count
,expr
)
Executes the expression (expr)
count
times. The result value is always 0.
For example:
BENCHMARK(1000000,ATAN2(3.1415, 1))
-> 0
number
)
Returns a string containing the binary value of
n
, where n
is a
BIGINT number.
string
Casts string
to a binary string.
expr
)
An aggregate function that returns the bitwise
AND of all bits in
expr
. The calculation is performed with
64-bit (BIGINT) precision. The value of -1 is returned when no matching ...
No credit card required