In MariaDB, ELT() is a built-in string function that accepts a numeric argument, followed by a series of string arguments. It then returns the string that corresponds to the given numeric position provided by the first argument.
Category: DBMS
Database Management Systems
How CONCAT_WS() Works in MariaDB
In MariaDB, CONCAT_WS() is a built-in string function that stands for Concatenate With Separator.
CONCAT_WS() performs a string concatenation on its arguments, with the first argument being the separator for the remaining arguments.
Concatenation is the operation of joining two or more strings end-to-end.
CONCAT_WS() accepts two or more arguments (although providing just two arguments would result in nothing being concatenated, due to the first argument being the separator, and the second being a single string to be concatenated with… nothing else).
How CONCAT() Works in MariaDB
In MariaDB, CONCAT() is a built-in string function that performs a string concatenation on its arguments. It returns the string that results from concatenating its arguments.
Concatenation is the operation of joining two or more strings end-to-end.
CONCAT() accepts one or more arguments, all of which are returned as a single concatenated string.
How OCTET_LENGTH() Works in MariaDB
In MariaDB, OCTET_LENGTH() is a built-in string function that returns the length of the given string argument, measured in octets (bytes).
OCTET_LENGTH() is a synonym for LENGTHB().
It’s also a synonym for LENGTH() when not in Oracle mode (LENGTH() behaves differently in Oracle mode).
MariaDB LENGTHB() Explained
In MariaDB, LENGTHB() is a built-in string function that returns the length of the given string argument, measured in bytes.
How LENGTH() Works in MariaDB
In MariaDB, LENGTH() is a built-in string function that returns the length of the given string argument.
When in default mode, the length of the string is measured in bytes. But when in Oracle mode, it’s measured in characters.
Continue readingMariaDB CHARACTER_LENGTH() Explained
In MariaDB, CHARACTER_LENGTH() is a built-in string function that returns the length of the given string argument, measured in characters.
CHARACTER_LENGTH() is actually a synonym for CHAR_LENGTH(), so you can use either.
How CHAR_LENGTH() Works in MariaDB
In MariaDB, CHAR_LENGTH() is a built-in string function that returns the length of the given string argument, measured in characters.
How CONVERT() Works in MariaDB
In MariaDB, CONVERT() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
You provide the value as an argument when you call the function, as well as the type that you’d like it converted to.
CONVERT() is similar to CAST().
How CAST() Works in MariaDB
In MariaDB, CAST() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
You provide the value as an argument when you call the function, as well as the type that you’d like it converted to.
CAST() works similar to CONVERT().