None and null

SurrealDB uses two types called None and Null to represent two different ways in which data may not exist.

None values

Values can be specifically set to NONE in SurrealDB to remove a field from a record.

CREATE person SET children = NONE;

The NONE keyword can be written in anycase.

CREATE person SET children = NONE, siblings = none;

Null values

Values can be specifically set to NULL in SurrealDB to denote a field which is set, but which does not have a value.

CREATE person SET children = NULL;

The NULL keyword can be written in anycase.

CREATE person SET children = NULL, siblings = null;