|
|
Ispirer SQLWays Database Migration Software
ENUM and SET
ENUM('value1','value2',...)
A character data that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special "" error value specified when the table is created. An ENUM can have a maximum of 65535 distinct values.
SET('value1','value2',...)
A character data that can have zero or more values, which must be chosen from the list of values 'value1', 'value2', ... specified when the table is created. A SET can have a maximum of 64 members.
|
|