What is the use of enum in MySQL? How it is different from set?
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
|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|