Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the CONNECTION_ID() function works in Mariadb?

The CONNECTION_ID() function is an information function that returns the connection ID of the current session. The connection ID is a unique identifier that is assigned to each client that connects to the server.

How the ENDPOINT() function works in Mariadb?

The ENDPOINT() function is a geometric function that returns the last point of a LineString geometry.

How the CONCAT() function works in Mariadb?

The CONCAT() function is a string function that concatenates two or more strings into one string. The function returns a string that is the result of joining the arguments in the order they appear.

MariaDB ENCRYPT() Function

Learn how MariaDB ENCRYPT() wraps the system crypt() call, handles salts, and why its result is not reversible encryption.

How the CONCAT_WS() function works in Mariadb?

The CONCAT_WS() function is a string function that concatenates two or more strings with a specified separator.

MariaDB ENCODE() Function

Learn how MariaDB ENCODE() pairs with DECODE(), what it returns, and why it must not be used to protect passwords or sensitive data.

How the COMPRESS() function works in Mariadb?

The COMPRESS() function is a string function that compresses a string and returns the result as a binary string.

How the ELT() function works in Mariadb?

The MariaDB ELT() function is used to return the N-th element from a list of strings.

How the COLLATION() function works in Mariadb?

The COLLATION() function is a string function that returns the name of the collation of a given string. The collation of a string determines how the string is sorted and compared.

How the DIV operator works in Mariadb?

The DIV operator is a built-in operator in Mariadb that performs integer division, which means it divides the dividend by the divisor and returns the integer result of the division with any decimal places truncated from the value.