MariaDB Reference

This page arranges the materials related to learning and using MariaDB.

To reformat a MariaDB query in your browser, use the SQL formatter. The MariaDB dialect is selected for you; the query stays in your browser and formatting does not execute or validate it.

MariaDB String Functions
- ASCII()
- BIN()
- BIT_LENGTH()
- CHAR_LENGTH()
- CHAR()
- CHARACTER_LENGTH()
- CHR()
- COMPRESS()
- CONCAT_WS()
- CONCAT()
- ELT()
- EXPORT_SET()
- FIELD()
- FIND_IN_SET()
- FORMAT()
- FROM_BASE64()
- HEX()
- INSERT()
- INSTR()
- LCASE()
- LEFT()
- LENGTH()
- LENGTHB()
- LOAD_FILE()
- LOCATE()
- LOWER()
- LPAD()
- LTRIM_ORACLE()
- LTRIM()
- MAKE_SET()
- MID()
- OCTET_LENGTH()
- ORD()
- POSITION()
- QUOTE()
- REGEXP_INSTR()
- REGEXP_REPLACE()
- REGEXP_SUBSTR()
- REPEAT()
- REPLACE()
- REVERSE()
- RIGHT()
- RPAD()
- RTRIM_ORACLE()
- RTRIM()
- SOUNDEX()
- SOUNDS LIKE
- SPACE()
- STRCMP()
- SUBSTR()
- SUBSTRING_INDEX()
- SUBSTRING()
- TO_BASE64()
- TO_CHAR()
- TRIM_ORACLE()
- TRIM()
- UCASE()
- UNCOMPRESS()
- UNCOMPRESSED_LENGTH()
- UNHEX()
- UPPER()
- WEIGHT_STRING()
MariaDB Math Functions
- ABS()
- ACOS()
- ASIN()
- ATAN()
- ATAN2()
- CEIL()
- CEILING()
- CONV()
- COS()
- COT()
- CRC32()
- CRC32C()
- DEGREES()
- EXP()
- FLOOR()
- LN()
- LOG()
- LOG10()
- LOG2()
- MOD()
- OCT()
- PI()
- POW()
- POWER()
- RADIANS()
- RAND()
- ROUND()
- SIGN()
- SIN()
- SQRT()
- TAN()
- TRUNCATE()
MariaDB Control Functions
- BENCHMARK()
- CAST()
- COALESCE()
- CONVERT()
- DEFAULT()
- GREATEST()
- IFNULL()
- ISNULL()
- LEAST()
- NULLIF()
- NVL()
- SLEEP()
MariaDB Data and Time Functions
- ADD_MONTHS()
- 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()
- TO_SECONDS()
- UNIX_TIMESTAMP()
- UTC_DATE()
- UTC_TIME()
- UTC_TIMESTAMP()
- WEEK()
- WEEKDAY()
- WEEKOFYEAR()
- YEAR()
- YEARWEEK()
MariaDB JSON Functions Reference
MariaDB Aggreagte Functions
- AVG()
- COUNT()
- GROUP_CONCAT()
- MAX()
- MIN()
- SUM()
MariaDB Information Function
MariaDB Operators
- BINARY
- CASE
- DIV
- EXCEPT
- INTERSECT
- IS JSON
- LIKE
- MINUS
- MOD
- NOT LIKE
- REGEXP
- RLIKE
- UNION
MariaDB XML Functions
- EXTRACTVALUE()
- UPDATEXML()
MariaDB Summary
MariaDB Data Types Reference
- JSON
- UUID