User Documentation
Ispirer Capabilities - MySQL Migration
Pricing
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