isnotemptyUUID
Checks whether an UUID is not empty.
Syntax​
isnotemptyUUID(x)
Arguments​
| Arguments | Description |
|---|---|
| x | A UUID. |
Return Type​
If x is not empty, isnotemptyUUID() returns 1, otherwise it returns 0.
Examples​
mysql> select isnotemptyUUID(generateUUIDv4());
+----------------------------------+
| isnotemptyUUID(generateUUIDv4()) |
+----------------------------------+
| 1 |
+----------------------------------+
mysql> select isnotemptyUUID(zeroUUID());
+----------------------------+
| isnotemptyUUID(zeroUUID()) |
+----------------------------+
| 0 |
+----------------------------+