Articles

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

How the LOAD_FILE() function works in Mariadb?

The LOAD_FILE() function is a string function that reads the content of a file and returns it as a string.

The MOD operator is a useful tool for performing the modulo operation, which returns the remainder of a division.

The SOUNDS LIKE operator in MariaDB is used to compare two strings based on their phonetic representations, similar to the SOUNDEX() function.

The JSON_CONTAINS() function is a JSON function that tests whether a JSON document contains a specific value at a given path or paths.

The LN() function is a mathematical function that returns the natural logarithm of a given number.

The MLineFromWKB() function is a useful tool for creating a multilinestring geometry from a well-known binary (WKB) representation.

The SOUNDEX() function in MariaDB is a string function that is used to evaluate the phonetic representation of two strings.

The JSON_CONTAINS_PATH() function is a JSON function that tests whether a JSON document contains any data at a given path or paths.

The LineStringFromWKB() function is a spatial function that converts a binary representation of a line to a geometry value.

The MLineFromText() function is a useful tool for creating a multilinestring geometry from a well-known text (WKT) representation.