STRING data type
Syntax
STRING
Arguments
Argument | Description |
---|---|
STRING | Used for STRING, CHAR and VARCHAR data. |
Additional information
The STRING data type has a keyed mutex
internal data type and recommended for queries:
- on discrete values,
- with
group by
where cardinality is low
High cardinality data will:
- decrease performance
- increase storage overheads
Constraining string values
Single quotation marks are used for string values in the following statements:
Examples
create table products
(_id id, item string, price decimal(2) stock int);
create table services
(_id id, servicelist string, price decimal(2));
SELECT FROM string column
SELECT * FROM products WHERE item LIKE '%pen%';