|
Function
|
Purpose
|
|---|---|
|
BITAND(integer1, integer2)
BIT_AND(integer1, integer2) |
Returns the result of the bitwise AND operation.
|
|
BITANDNOT(expression1,expression2)
BIT_ANDNOT(expression1,expression2) |
Clears any bit in the first argument that is in the second argument.
|
|
BITNOT(expression)
|
Performs a bitwise NOT operation.
|
|
BITOR(expression1,expression2)
|
Performs a bitwise OR operation.
|
|
BITXOR(expression1,expression2)
|
Performs a bitwise exclusive OR operation.
|
|
IFNULL(exp, value)
|
If exp is null, returns value; if not, returns exp
(if value is returned, it is converted to type of exp)
|
|
NEW_UUID()
|
Generates a new 16-byte GUID
|
|
SLEEP(milliseconds)
|
The SLEEP function can be called only from a stored procedure or a trigger. It causes the stored procedure or trigger to "sleep" (temporarily suspend activity) for the specified number of milliseconds. Resolution is accurate to approximately 1 second (1000 milliseconds). The exact length of the sleep also depends upon how busy the computer is with other processes and threads. The value must be a literal, not a variable or expression.
|