SET Data Type
Syntax
SET('value1','value2',...) [CHARACTER SET charset_name] [COLLATE collation_name]
Description
A set. A string object that can have zero or more values, each of which must be chosen from the list of values 'value1', 'value2', ... A SET column can have a maximum of 64 members. SET values are represented internally as integers.
SET values cannot contain commas.
If a SET contains duplicate values, an error will be returned if strict mode is enabled, or a warning if strict mode is not enabled.
EXAMPLES
CREATE TABLE set_example (
description VARCHAR(20),
example SET('Foo', 'Bar', 'Baz', 'Bob')
);
INSERT INTO set_example VALUES
('1 val', 'Foo'),
('2 vals', 'Baz,Foo'),
('4 vals', 'Bob,Foo,Bar,Foo,Baz,Bob');
SELECT * FROM set_example; +-------------+-----------------+ | description | example | +-------------+-----------------+ | 1 val | Foo | | 2 vals | Foo,Baz | | 4 vals | Foo,Bar,Baz,Bob | +-------------+-----------------+
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
