MySQL Functions [Ispirer Migration Knowledge Base]

Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Functions

SQL Functions Mapping to Other Databases
Numeric Functions
- ABS
- ACOS
- ASIN
- ATAN
- ATAN2
- CEILING
- CONV
- COS
- COT
- CRC32
- DEGREES
- DIV
- EXP
- FLOOR
- LN
- LOG10
- LOG2
- LOG
- MOD
- PI
- POWER
- RADIANS
- RAND
- ROUND
- SIGN
- SIN
- SQRT
- TAN
- TRUNCATE
String Functions
- ASCII
- BIN
- BIT_COUNT
- BIT_LENGTH
- CHAR_LENGTH
- CHAR
- CONCAT_WS
- CONCAT
- ELT
- EXPORT_SET
- FIELD
- FIND_IN_SET
- INSERT
- INSTR
- LEFT
- LENGTH
- LOCATE
- LOWER
- LPAD
- LTRIM
- MAKE_SET
- OCT
- OCTET_LENGTH
- ORD
- QUOTE
- REGEXP
- REPEAT
- REPLACE
- REVERSE
- RIGHT
- RPAD
- RTRIM
- SOUNDEX
- SPACE
- STRCMP
- SUBSTR
- SUBSTRING_INDEX
- TRIM
- UPPER
- WEIGHT_STRING
Date and Time Functions
- ADDDATE
- ADDTIME
- CONVERT_TZ
- CURDATE
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURTIME
- DATE_ADD
- DATE_FORMAT
- DATE_SUB
- DATE
- DATEDIFF
- DAY
- DAYNAME
- DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- FROM_DAYS
- FROM_UNIXTIME
- GET_FORMAT
- HOUR
- LAST_DAY
- LOCALTIME
- LOCALTIMESTAMP
- MAKEDATE
- MAKETIME
- MICROSECOND
- MINUTE
- MONTH
- MONTHNAME
- NOW
- PERIOD_ADD
- PERIOD_DIFF
- QUARTER
- SEC_TO_TIME
- SECOND
- STR_TO_DATE
- SUBDATE
- SUBTIME
- SYSDATE
- TIME_FORMAT
- TIME_TO_SEC
- TIME
- TIMEDIFF
- TIMESTAMP
- TIMESTAMPADD
- TIMESTAMPDIFF
- TO_DAYS
- UNIX_TIMESTAMP
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- WEEK
- WEEKDAY
- WEEKOFYEAR
- YEAR
- YEARWEEK
Analitic and Aggregate Functions
- AVG
- BIT_AND
- BIT_OR
- BIT_XOR
- COUNT(DISTINCT)
- COUNT
- GROUP_CONCAT
- MAX
- MIN
- STD
- STDDEV_POP
- STDDEV_SAMP
- STDDEV
- SUM
- VAR_POP
- VAR_SAMP
- VARIANCE
Conversion Functions
- BINARY
- CAST
- Convert
- AES_DECRYPT
- AES_ENCRYPT
- COMPRESS
- UNCOMPRESS
- UNCOMPRESSED_LENGTH
- DECODE
- DES_DECRYPT
- DES_ENCRYPT
- ENCODE
- ENCRYPT
- FORMAT
- HEX
- UNHEX
XML Functions
- ExtractValue
- UpdateXML
Environment and System Functions
- BENCHMARK
- CHARSET
- COERCIBILITY
- COLLATION
- CONNECTION_ID
- CURRENT_USER
- DATABASE
- DEFAULT
- FOUND_ROWS
- GET_LOCK
- INET_ATON
- INET_NTOA
- IS_FREE_LOCK
- IS_USED_LOCK
- LAST_INSERT_ID
- MASTER_POS_WAIT
- NAME_CONST
- RELEASE_LOCK
- ROW_COUNT
- SCHEMA
- SESSION_USER
- SLEEP
- SYSTEM_USER
- USER
- UUID
- UUID_SHORT
- VALUES
- VERSION
- OLD_PASSWORD
- PASSWORD
Other Functions
- CASE
- IF
- IFNULL
- NULLIF
- MD5
- SHA1
- LIKE
- LOAD_FILE
- MATCH
- SOUNDS LIKE