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
BY Best Interview Question ON 11 Mar 2020