Functions, Operators, and Procedures in MariaDB
-
Bit Functions
&, ^, , |, BIT_COUNT -
Comparison operators
!=, <, <=, <=>, >=, >, and etc... -
Control flow functions
CASE, IF, IFNULL, NULLIF -
Date and Time Functions
CURDATE, DAYNAME, DATEDIFF, TIME, and etc... -
Encryption Functions
ENCRYPT, DECRYPT, COMPRESS, and etc... -
Functions and Modifiers for use with GROUP BY
AVG, MIN, MAX, STD, COUNT, and etc... -
Information Functions
BENCHMARK, CHARSET, DATABASE, USER, VERSION, and etc.. -
Logical operators
!, &&, XOR, || -
Miscellaneous Functions
DEFAULT, GET_LOCK, SLEEP, UUID, and etc... -
Numeric functions
ABS, CEIL, DIV, EXP, PI, SIN, and etc... -
String functions
CHAR, CONVERT, CONCAT, PAD, REGEXP, TRIM, and etc... -
User-defined Functions
CREATE/DROP FUNCTION UDF -
PROCEDURE ANALYSE
Syntax: analyse([max_elements[,max_memory]])Description: This procedure is ... -
TRUE FALSE
Description The constants TRUE and FALSE evaluate to 1 and 0, respectively....
