_sidebar.md

• Built-in Functions
  • Aggregate Functions
    • AVG
    • BIT_AND
    • BIT_OR
    • BIT_XOR
    • COUNT
    • COUNT DISTINCT
    • GROUP_CONCAT
    • MAX
    • MIN
    • STD
    • STDDEV
    • STDDEV_POP
    • STDDEV_SAMP
    • SUM
    • VARIANCE
    • VAR_POP
    • VAR_SAMP
  • Control Flow Functions
    • CASE OPERATOR
    • DECODE_ORACLE
    • IF Function
    • IFNULL
    • NULLIF
    • NVL
    • NVL2
  • Date & Time Functions
    • ADDDATE
    • ADDTIME
    • CONVERT_TZ
    • CURDATE
    • CURRENT_DATE
    • CURRENT_TIME
    • CURRENT_TIMESTAMP
    • CURTIME
    • Date and Time Units
    • DATE FUNCTION
    • DATEDIFF
    • DATE_ADD
    • DATE_FORMAT
    • DATE_SUB
    • DAY
    • DAYNAME
    • DAYOFMONTH
    • DAYOFWEEK
    • DAYOFYEAR
    • EXTRACT
    • FROM_DAYS
    • FROM_UNIXTIME
    • GET_FORMAT
    • HOUR
    • LAST_DAY
    • LOCALTIME
    • LOCALTIMESTAMP
    • MAKEDATE
    • MAKETIME
    • MICROSECOND
    • Microseconds in MariaDB
    • MINUTE
    • MONTH
    • MONTHNAME
    • NOW
    • PERIOD_ADD
    • PERIOD_DIFF
    • QUARTER
    • SECOND
    • SEC_TO_TIME
    • STR_TO_DATE
    • SUBDATE
    • SUBTIME
    • SYSDATE
    • TIME Function
    • TIMEDIFF
    • TIMESTAMP FUNCTION
    • TIMESTAMPADD
    • TIMESTAMPDIFF
    • TIME_FORMAT
    • TIME_TO_SEC
    • TO_DAYS
    • TO_SECONDS
    • UNIX_TIMESTAMP
    • UTC_DATE
    • UTC_TIME
    • UTC_TIMESTAMP
    • WEEK
    • WEEKDAY
    • WEEKOFYEAR
    • YEAR
    • YEARWEEK
  • Function and Operator Reference
  • Numeric Functions
    • ABS
    • ACOS
    • Addition Operator (+)
    • ASIN
    • ATAN
    • ATAN2
    • CEIL
    • CEILING
    • CONV
    • COS
    • COT
    • CRC32
    • DEGREES
    • DIV
    • Division Operator (/)
    • EXP
    • FLOOR
    • LN
    • LOG
    • LOG10
    • LOG2
    • MOD
    • Modulo Operator (%)
    • Multiplication Operator (*)
    • OCT
    • PI
    • POW
    • POWER
    • RADIANS
    • RAND
    • ROUND
    • SIGN
    • SIN
    • SQRT
    • TAN
    • TRUNCATE
  • Pseudo Columns
    • _rowid
  • Secondary Functions
    • Bit Functions and Operators
    • Encryption, Hashing and Compression Functions
    • Information Functions
    • Miscellaneous Functions
  • Special Functions
    • Dynamic Columns Functions
    • Geographic Functions
    • JSON Functions
    • Window Functions
  • String Functions
    • ASCII
    • BIN
    • BINARY Operator
    • BIT_LENGTH
    • CAST
    • CHAR Function
    • CHARACTER_LENGTH
    • CHAR_LENGTH
    • CHR
    • CONCAT
    • CONCAT_WS
    • CONVERT
    • ELT
    • EXPORT_SET
    • EXTRACTVALUE
    • FIELD
    • FIND_IN_SET
    • FORMAT
    • FROM_BASE64
    • HEX
    • INSERT Function
    • INSTR
    • LCASE
    • LEFT
    • LENGTH
    • LENGTHB
    • LIKE
    • LOAD_FILE
    • LOCATE
    • LOWER
    • LPAD
    • LTRIM
    • MAKE_SET
    • MATCH AGAINST
    • MID
    • NOT LIKE
    • NOT REGEXP
    • OCTET_LENGTH
    • ORD
    • POSITION
    • QUOTE
    • Regular Expressions Functions
    • REPEAT Function
    • REPLACE Function
    • REVERSE
    • RIGHT
    • RPAD
    • RTRIM
    • SOUNDEX
    • SOUNDS LIKE
    • SPACE
    • STRCMP
    • SUBSTR
    • SUBSTRING
    • SUBSTRING_INDEX
    • TO_BASE64
    • TRIM
    • TRIM_ORACLE
    • Type Conversion
    • UCASE
    • UNHEX
    • UPDATEXML
    • UPPER
    • WEIGHT_STRING
• Clients & Utilities
  • Aria Clients and Utilities
    • aria_chk
    • aria_pack
    • aria_read_log
  • Backup, Restore and Import Clients
    • mariadb-dump
    • mariadb-hotcopy
    • mariadb-import
    • mysqldump
    • mysqlhotcopy
    • mysqlimport
  • dbForge Studio for MariaDB
  • dbdeployer
  • EXPLAIN Analyzer
  • EXPLAIN Analyzer API
  • Graphical and Enhanced Clients
    • Beekeeper Studio
    • Database Workbench
    • dbForge Data Compare
    • dbForge Data Generator
    • dbForge Documenter
    • dbForge Fusion
    • dbForge Query Builder
    • dbForge Schema Compare
    • dbForge Studio for MariaDB
    • DbSchema
    • ERBuilder Data Modeler
    • DBeaver
    • Improved SQL Document Parser Performance in Updated dbForge Tools for MySQL and MariaDB
    • OmniDB
    • Sequel Pro
    • HeidiSQL
    • LibreOffice Base
    • Moon Modeler
    • mycli
    • Navicat
    • ocelotgui
    • phpMyAdmin
    • Querious
    • SB Data Generator
    • SQL Diagnostic Manager & SQLyog
    • SQLPro Studio
    • SQLTool Pro Database Editor
    • SQLyog: Community Edition
    • TablePlus
    • TOAD Edge
    • TOAD for MySQL
    • Valentina Studio
  • innochecksum
  • mariadb-access
  • mariadb-admin
  • mariadb-check
  • mariadb-conv
  • mariadb-convert-table-format
  • mariadb-dumpslow
  • mariadb-embedded
  • mariadb-find-rows
  • mariadb-fix-extensions
  • mariadb-install-db
  • mariadb-plugin
  • mariadb-report
  • mariadb-secure-installation
  • mariadb-setpermission
  • mariadb-show
  • mariadb-slap
  • mariadb-tzinfo-to-sql
  • mariadb-upgrade
  • mariadb-waitpid
  • msql2mysql
  • MyISAM Clients and Utilities
    • Memory and Disk Use With myisamchk
    • myisamchk
    • myisamchk Table Information
    • myisamlog
    • myisampack
    • myisam_ftdump
  • mysql Client
    • Delimiters
    • mariadb Command-Line Client
    • mysql Command-line Client
  • MySQL Sandbox
  • mysql-stress-test
  • mysqlaccess
  • mysqladmin
  • mysqlbinlog
    • Annotate_rows_log_event
    • mariadb-binlog
    • mysqlbinlog Options
    • Using mysqlbinlog
  • mysqldumpslow
  • mysqlreport
  • mysqlshow
  • mysqlslap
  • mysql-test
    • Installing MinIO for Usage With mysql-test-run
    • mysql-test Auxiliary Files
    • mysql-test Overview
    • mysql-test-run.pl Options
    • New Features for mysqltest in MariaDB
    • Pausing mysql-test-run.pl
    • The Debug Sync Facility
  • mysql_convert_table_format
  • mysql_embedded
  • mysql_find_rows
  • mysql_fix_extensions
  • mysql_install_db
  • mysql_plugin
  • mysql_secure_installation
  • mysql_setpermission
  • mysql_tzinfo_to_sql
  • mysql_waitpid
  • mysql_zap
  • my_print_defaults
  • perror
  • replace Utility
  • resolveip
  • resolve_stack_dump
  • xtstat
• Columns, Storage Engines, and Plugins
  • Data Types
    • AUTO_INCREMENT
    • AUTO_INCREMENT FAQ
    • Data Type Storage Requirements
    • Numeric Data Types
    • Date and Time Data Types
    • NULL Values
    • String Data Types
  • Plugins
    • Authentication Plugins
    • Information on Plugins
    • Installing, Using, and Creating Plugins
    • MariaDB Audit Plugin
    • MariaDB Replication & Cluster Plugins
    • Other Plugins
    • Password Validation Plugins
    • Plugin Overview
  • Storage Engines
    • Archive
    • Aria
    • BLACKHOLE
    • Choosing the Right Storage Engine
    • CONNECT
    • Converting Tables from MyISAM to InnoDB
    • CSV
    • FederatedX
    • InnoDB
    • Legacy Storage Engines
    • Machine Learning with MindsDB
    • MariaDB ColumnStore
    • MEMORY Storage Engine
    • MERGE
    • Mroonga
    • MyISAM
    • MyRocks
    • OQGRAPH
    • PERFORMANCE_SCHEMA Storage Engine
    • S3 Storage Engine
    • Sequence Storage Engine
    • SphinxSE
    • Spider
    • Storage Engine Development
    • TokuDB
• MariaDB Administration
  • Backing Up and Restoring Databases
    • Percona XtraBackup
    • Backup and Restore Overview
    • Mariabackup
    • Replication as a Backup Solution
  • Copying Tables Between Different MariaDB Databases and MariaDB Servers
  • Getting, Installing, and Upgrading MariaDB
    • MariaDB Binary Packages
    • Compiling MariaDB From Source
    • Configuring MariaDB with Option Files
    • Downgrading between Major Versions of MariaDB
    • Installing MariaDB on IBM Cloud
    • Installing System Tables (mysql_install_db)
    • MariaDB Environment Variables
    • MariaDB on Amazon RDS
    • MariaDB Performance & Advanced Configurations
    • Migrating from SQL Server to MariaDB
    • mysqld Configuration Files and Groups
    • mysql_install_db.exe
    • Obsolete Installation Information
    • Puppet and MariaDB
    • Starting and Stopping MariaDB
    • Troubleshooting Installation Issues
    • Upgrading MariaDB
  • Partitioning Tables
    • Partition Maintenance
    • Partition Pruning and Selection
    • Partitioning Limitations with MariaDB
    • Partitioning Overview
    • Partitioning Types
    • Partitions Files
    • Partitions Metadata
  • Server Monitoring & Logs
    • Binary Log
    • Error Log
    • General Query Log
    • MyISAM Log
    • Overview of MariaDB Logs
    • Rotating Logs on Unix and Linux
    • Slow Query Log
    • SQL Error Log Plugin
    • Transaction Coordinator Log
    • Writing Logs Into Tables
  • User & Server Security
    • Securing MariaDB
    • User Account Management
  • Variables and Modes
    • Full List of MariaDB Options, System and Status Variables
    • OLD_MODE
    • SQL_MODE
• MariaDB Platform X3
  • Sample Platform X3 implementation for Transactional and Analytical Workloads
• Migrating to MariaDB
  • Migrating to MariaDB from MySQL
  • Migrating to MariaDB from Other Databases
    • Migrating to MariaDB from PostgreSQL
    • Oracle XE 11.2. and MariaDB 10.1 integration on Ubuntu 14.04 and Debian systems
• Programming & Customizing MariaDB
  • Programmatic & Compound Statements
    • BEGIN END
    • CASE Statement
    • DECLARE CONDITION
    • DECLARE HANDLER
    • DECLARE Variable
    • FOR
    • GOTO
    • IF
    • ITERATE
    • Labels
    • LEAVE
    • LOOP
    • Cursors
    • Diagnostics
    • REPEAT LOOP
    • RESIGNAL
    • RETURN
    • SELECT INTO
    • SET Variable
    • SIGNAL
    • Using Compound Statements Outside of Stored Programs
    • WHILE
  • Stored Routines
    • Binary Logging of Stored Routines
    • Stored Functions
    • Stored Procedures
    • Stored Routine Limitations
  • Triggers & Events
    • Event Scheduler
    • Triggers
  • User-Defined Functions
    • CREATE FUNCTION UDF
    • Creating User-Defined Functions
    • DROP FUNCTION UDF
    • User-Defined Functions Calling Sequences
    • User-Defined Functions Security
  • Views
    • ALTER VIEW
    • CREATE VIEW
    • DROP VIEW
    • Information Schema VIEWS Table
    • Inserting and Updating with Views
    • View Algorithms
• High Availability & Performance Tuning
• SQL Statements & Structure
  • Geographic & Geometric Features
    • GeoJSON
    • Geometry Constructors
    • Geometry Hierarchy
    • Geometry Properties
    • Geometry Relations
    • Geometry Types
    • GIS features in 5.3.3
    • GIS Resources
    • LineString Properties
    • MariaDB Plans - GIS
    • MBR (Minimum Bounding Rectangle)
    • MySQL/MariaDB Spatial Support Matrix
    • Point Properties
    • Polygon Properties
    • SPATIAL INDEX
    • The maria/5.3-gis tree on Launchpad.
    • WKB
    • WKT
  • NoSQL
    • Dynamic Column API
    • Dynamic Columns
    • Dynamic Columns API
    • Dynamic Columns from MariaDB 10
    • HANDLER
    • HandlerSocket
  • Operators
    • Arithmetic Operators
    • Assignment Operators
    • Comparison Operators
    • Logical Operators
    • Operator Precedence
  • Sequences
    • ALTER SEQUENCE
    • CREATE SEQUENCE
    • DROP SEQUENCE
    • SEQUENCE Functions
    • Sequence Overview
  • SQL Language Structure
    • Binary Literals
    • Date and Time Literals
    • Hexadecimal Literals
    • Identifier Case-sensitivity
    • Identifier Names
    • Identifier Qualifiers
    • Identifier to File Name Mapping
    • MariaDB Error Codes
    • Numeric Literals
    • Reserved Words
    • Boolean Literals
    • String Literals
    • Table Value Constructors
    • User-Defined Variables
  • SQL Statements
    • Account Management SQL Commands
    • Administrative SQL Statements
    • Comment Syntax
    • Data Definition
    • Data Manipulation
    • Prepared Statements
    • Stored Routine Statements
    • Table Statements
    • Transactions
  • Temporal Tables
    • Application-Time Periods
    • Bitemporal Tables
    • System-Versioned Tables