How many values can an enum have?

A string object that can have only one value, chosen from the list of values ‘value1’, ‘value2’, …, NULL or the special ” error value. 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 more

Can enums be numbers?

Numeric enums are number-based enums i.e. they store string values as numbers. Enums are always assigned numeric values when they are stored. The first value always takes the numeric value of 0, while the other values in the enum are incremented by 1.

Read more