This section provides an alphabetical listing of MySQL-supported functions, with examples and corresponding results.
Returns the arc cosine of
from -1 to 1. The result ranges from 0 to and is expressed in
radians. For example:
SELECT ACOS( 0 )-> 1.570796
Returns the ASCII code of the first character of
text. For example:
SELECT ASCII('x')-> 120
Returns the arc sine of
from -1 to 1. The resulting value ranges from -/2 to /2 and is
expressed in radians. For example:
SELECT ASIN( 0 )-> 0.000000
Returns the arctangent of any
resulting value ranges from -/2 to /2 and is expressed in radians.
SELECT ATAN( 3.1415 )-> 1.262619
Returns the arctangent of the two variables
is similar to
with the exception that the signs of
y are used to determine the quadrant of
the result. For example:
ATAN2(3.1415, 1)-> 1.262619
Executes the expression
count times. The result value is always 0.
BENCHMARK(1000000,ATAN2(3.1415, 1))-> 0
Returns a string containing the binary value of
n is a
string to a binary string.
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 ...