跳到主要内容

IS_NOT_EMPTY_UUID

Checks whether an UUID is not empty.

Syntax

IS_NOT_EMPTY_UUID( <uuid> )

Arguments

ArgumentsDescription
<uuid>A UUID string.

Return Type

If x is not empty, IS_NOT_EMPTY_UUID() returns 1, otherwise it returns 0.

Examples

SELECT is_not_empty_uuid(gen_random_uuid());
+--------------------------------------+
| is_not_empty_uuid(gen_random_uuid()) |
+--------------------------------------+
| 1 |
+--------------------------------------+

SELECT is_not_empty_uuid(gen_zero_uuid());
+------------------------------------+
| is_not_empty_uuid(gen_zero_uuid()) |
+------------------------------------+
| 0 |
+------------------------------------+