数据库教程
Sakila
MySQL
MySQL 参考
PostgreSQL
MariaDB 参考资料
本页整理了学习和使用 MariaDB 的相关资料，包括常用的函数、操作符。
MariaDB 字符串函数参考
MariaDB ASCII()
MariaDB BIN()
MariaDB BIT_LENGTH()
MariaDB CHAR_LENGTH()
MariaDB CHAR()
MariaDB CHARACTER_LENGTH()
MariaDB CHR()
MariaDB COMPRESS()
MariaDB CONCAT_WS()
MariaDB CONCAT()
MariaDB ELT()
MariaDB EXPORT_SET()
MariaDB FIELD()
MariaDB FIND_IN_SET()
MariaDB FORMAT()
MariaDB FROM_BASE64()
MariaDB HEX()
MariaDB INSERT()
MariaDB INSTR()
MariaDB LCASE()
MariaDB LEFT()
MariaDB LENGTH()
MariaDB LENGTHB()
MariaDB LOAD_FILE()
MariaDB LOCATE()
MariaDB LOWER()
MariaDB LPAD()
MariaDB LTRIM_ORACLE()
MariaDB LTRIM()
MariaDB MAKE_SET()
MariaDB MID()
MariaDB OCTET_LENGTH()
MariaDB ORD()
MariaDB POSITION()
MariaDB QUOTE()
MariaDB REGEXP_INSTR()
MariaDB REGEXP_REPLACE()
MariaDB REGEXP_SUBSTR()
MariaDB REPEAT()
MariaDB REPLACE()
MariaDB REVERSE()
MariaDB RIGHT()
MariaDB RPAD()
MariaDB RTRIM_ORACLE()
MariaDB RTRIM()
MariaDB SOUNDEX()
MariaDB SOUNDS LIKE
MariaDB SPACE()
MariaDB STRCMP()
MariaDB SUBSTR()
MariaDB SUBSTRING_INDEX()
MariaDB SUBSTRING()
MariaDB TO_BASE64()
MariaDB TO_CHAR()
MariaDB TRIM_ORACLE()
MariaDB TRIM()
MariaDB UCASE()
MariaDB UNCOMPRESS()
MariaDB UNCOMPRESSED_LENGTH()
MariaDB UNHEX()
MariaDB UPPER()
MariaDB WEIGHT_STRING()
MariaDB 数学函数参考
MariaDB ABS()
MariaDB ACOS()
MariaDB ASIN()
MariaDB ATAN()
MariaDB ATAN2()
MariaDB CEIL()
MariaDB CEILING()
MariaDB CONV()
MariaDB COS()
MariaDB COT()
MariaDB CRC32()
MariaDB CRC32C()
MariaDB DEGREES()
MariaDB EXP()
MariaDB FLOOR()
MariaDB LN()
MariaDB LOG()
MariaDB LOG10()
MariaDB LOG2()
MariaDB MOD()
MariaDB OCT()
MariaDB PI()
MariaDB POW()
MariaDB POWER()
MariaDB RADIANS()
MariaDB RAND()
MariaDB ROUND()
MariaDB SIGN()
MariaDB SIN()
MariaDB SQRT()
MariaDB TAN()
MariaDB TRUNCATE()
MariaDB 控制函数
MariaDB BENCHMARK()
MariaDB CAST()
MariaDB COALESCE()
MariaDB CONVERT()
MariaDB DEFAULT()
MariaDB GREATEST()
MariaDB IFNULL()
MariaDB ISNULL()
MariaDB LEAST()
MariaDB NULLIF()
MariaDB NVL()
MariaDB SLEEP()
MariaDB 日期时间函数参考
MariaDB ADD_MONTHS()
MariaDB ADDDATE()
MariaDB ADDTIME()
MariaDB CONVERT_TZ()
MariaDB CURDATE()
MariaDB CURRENT_DATE()
MariaDB CURRENT_TIME()
MariaDB CURRENT_TIMESTAMP()
MariaDB CURTIME()
MariaDB DATE_ADD()
MariaDB DATE_FORMAT()
MariaDB DATE_SUB()
MariaDB DATE()
MariaDB DATEDIFF()
MariaDB DAY()
MariaDB DAYNAME()
MariaDB DAYOFMONTH()
MariaDB DAYOFWEEK()
MariaDB DAYOFYEAR()
MariaDB EXTRACT()
MariaDB FROM_DAYS()
MariaDB FROM_UNIXTIME()
MariaDB GET_FORMAT()
MariaDB HOUR()
MariaDB LAST_DAY
MariaDB LOCALTIME()
MariaDB LOCALTIMESTAMP()
MariaDB MAKEDATE()
MariaDB MAKETIME()
MariaDB MICROSECOND()
MariaDB MINUTE()
MariaDB MONTH()
MariaDB MONTHNAME()
MariaDB NOW()
MariaDB PERIOD_ADD()
MariaDB PERIOD_DIFF()
MariaDB QUARTER()
MariaDB SEC_TO_TIME()
MariaDB SECOND()
MariaDB STR_TO_DATE()
MariaDB SUBDATE()
MariaDB SUBTIME()
MariaDB SYSDATE()
MariaDB TIME_FORMAT()
MariaDB TIME_TO_SEC()
MariaDB TIME()
MariaDB TIMEDIFF()
MariaDB TIMESTAMP()
MariaDB TIMESTAMPADD()
MariaDB TIMESTAMPDIFF()
MariaDB TO_DAYS()
MariaDB TO_SECONDS()
MariaDB UNIX_TIMESTAMP()
MariaDB UTC_DATE()
MariaDB UTC_TIME()
MariaDB UTC_TIMESTAMP()
MariaDB WEEK()
MariaDB WEEKDAY()
MariaDB WEEKOFYEAR()
MariaDB YEAR()
MariaDB YEARWEEK()
MariaDB JSON 函数参考
MariaDB JSON_ARRAY_APPEND()
MariaDB JSON_ARRAY_INSERT()
MariaDB JSON_ARRAY()
MariaDB JSON_ARRAYAGG()
MariaDB JSON_COMPACT()
MariaDB JSON_CONTAINS_PATH()
MariaDB JSON_CONTAINS()
MariaDB JSON_DEPTH()
MariaDB JSON_DETAILED()
MariaDB JSON_EXISTS()
MariaDB JSON_EXTRACT()
MariaDB JSON_INSERT()
MariaDB JSON_KEYS()
MariaDB JSON_LENGTH()
MariaDB JSON_LOOSE()
MariaDB JSON_MERGE_PATCH()
MariaDB JSON_MERGE_PRESERVE()
MariaDB JSON_MERGE()
MariaDB JSON_OBJECT()
MariaDB JSON_OBJECTAGG()
MariaDB JSON_QUERY()
MariaDB JSON_QUOTE()
MariaDB JSON_REMOVE()
MariaDB JSON_REPLACE()
MariaDB JSON_SEARCH()
MariaDB JSON_SET()
MariaDB JSON_TABLE()
MariaDB JSON_TYPE()
MariaDB JSON_UNQUOTE()
MariaDB JSON_VALID()
MariaDB JSON_VALUE()
MariaDB 聚合函数参考
MariaDB AVG()
MariaDB COUNT()
MariaDB GROUP_CONCAT()
MariaDB MAX()
MariaDB MIN()
MariaDB SUM()
MariaDB Information 函数参考
MariaDB CHARSET()
MariaDB COERCABILITY()
MariaDB COLLATION()
MariaDB CONNECTION_ID()
MariaDB CURRENT_ROLE()
MariaDB CURRENT_USER()
MariaDB DATABASE()
MariaDB FOUND_ROWS()
MariaDB LAST_INSERT_ID()
MariaDB ROW_COUNT()
MariaDB ROWNUM()
MariaDB SCHEMA()
MariaDB SESSION_USER()
MariaDB SYS_GUID()
MariaDB SYSTEM_USER()
MariaDB USER()
MariaDB UUID_SHORT()
MariaDB UUID()
MariaDB VERSION()
MariaDB 操作符参考
MariaDB BINARY
MariaDB CASE
MariaDB DIV
MariaDB EXCEPT
MariaDB INTERSECT
MariaDB LIKE
MariaDB MINUS
MariaDB MOD
MariaDB NOT LIKE
MariaDB REGEXP
MariaDB RLIKE
MariaDB UNION
MariaDB XML 函数参考
MariaDB EXTRACTVALUE()
MariaDB UPDATEXML()
MariaDB 知识点
JSON 函数
排序规则
区域设置
日期格式说明符
日期和时间单位
日期和时间函数
数字函数
字符集