Hello,
can you please tell me what's the difference between data type enum and set?
Thank you!
Difference between set and enum?
I'm not sure how it's implemented internally, but 'enum' allows you to select one, and only one, value from a list, while 'set' allows you to select many (in MySQL, up to 64) values.
ENUM uses integers behind the scenes.
Well, presumably SET uses bitwise flags, which probably uses 64 bit integers as bit-fields.
That's probably right since SET can use up to 64 different members.
Powers of 2 are suspect like that 