We need more values then we need to change the list of possible values from the database which is more difficult for non programmers. The storage limits for ENUM types is 65535 possible values in the list and also a SET can allow upto 64 distinct values which are the chosen values in the set.
Read moreHow many values can enum have?
In theory, an ENUM column can have a maximum of 65,535 distinct values ; in practice, the real maximum depends on many factors. ENUM values are represented internally as integers.
Read moreCan enum have multiple values C++?
An enum instance may hold multiple values only as much as an int can : that is, not at all.
Read moreCan enum have multiple values python?
Enums can’t have multiple value per name .
Read more