Default value types
| Type | Example | Description |
|---|---|---|
| String | DEFAULT "value" | Default string literal |
| Number | DEFAULT 0 | Default numeric value |
| Timestamp | DEFAULT NOW | Automatically set to current timestamp on creation |
Example
In the example below, theage field has not been provided when inserting the item so the default value of 0 will be used.