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
datewithdaysadded to it. For example:SELECT ADDDATE('2008-05-14', 1)-> '2008-05-15'- ADDDATE(
date, INTERVALexpr unit) Returns
datewithexprunits ofunitadded. For example:SELECT ADDDATE('2008-05-14', INTERVAL 1 DAY)-> '2008-05-15'- AES_DECRYPT(
crypt_str,key_str) Returns
crypt_strdecrypted using AES and the keykey_str.- AES_ENCRYPT(
str,key_str) Returns
strencrypted 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
xandy. ATAN2(x,y) is similar to ATAN(y/x), with the exception that the signs ofxandyare used to determine the quadrant of the result. For example:ATAN2(3.1415, ...