MySQL-Supported Functions
This section provides an alphabetical listing of MySQL-supported functions, with examples and corresponding results.
- ACOS(
number
) Returns the arccosine 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- ADDDATE(
date
,days
) Returns
date
withdays
added to it. For example:SELECT ADDDATE('2008-05-14', 1)
-> '2008-05-15'- ADDDATE(
date
, INTERVALexpr unit
) Returns
date
withexpr
units ofunit
added. For example:SELECT ADDDATE('2008-05-14', INTERVAL 1 DAY)
-> '2008-05-15'- AES_DECRYPT(
crypt_str
,key_str
) Returns
crypt_str
decrypted using AES and the keykey_str
.- AES_ENCRYPT(
str
,key_str
) Returns
str
encrypted with AES using the keykey_str
. For example:SELECT AES_DECRYPT(AES_ENCRYPT('secret sauce', 'password'), 'password')
-> 'secret sauce'- ASCII(
text
) Returns the ASCII code of the first character of
text
. For example:SELECT ASCII('x')
-> 120- ASIN(
number
) Returns the arcsine 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- ATAN(
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- ATAN2(
x
,y
) Returns the arctangent of the two variables
x
andy
. ATAN2(x
,y
) is similar to ATAN(y
/x
), with the exception that the signs ofx
andy
are used to determine the quadrant of the result. For example:ATAN2(3.1415, ...
Get SQL in a Nutshell, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.