In MySQL, an ENUM is actually a string object whose value is selected from the list of permitted values pre-defined during the time of a column creation. It is used because it provides compact data storage in addition to readable queries and output.

Here’s the difference between an ENUM and a SET

ENUM SET
The value should be one listed in the column definition or internal numeric equivalent. Must be an empty string consisting of values listed in column

Suggest An Answer

No suggestions Available!